Replies

Under Tools/Internet Options/Security there are options for scripting – maybe that’s it?

How about adding a suitably formatted blank table into your header as a watermark?
You just need to check your line spacing, top margin etc. were consistent.

I have a similar need, but the security may not be enough for you as any user could go Tools/Options/Show Tabs to navigate to other sheets. (This purely prevents them accidentally entering expense claims onto the wrong sheet.)
It also depends on the user being correctly logged in with the Application User data being correct.
This goes in the ‘ThisWorkbook’ sheet in VB:

Private Sub Workbook_Open()
un = Left$(Application.UserName, 3)
If un = “Lei” Then Worksheets(3).Activate: ActiveWindow.DisplayWorkbookTabs = True
If un = “Ann” Then Worksheets(4).Activate: ActiveWindow.DisplayWorkbookTabs = False
If un = “Pau” Then Worksheets(2).Activate: ActiveWindow.DisplayWorkbookTabs = False
If un = “Tin” Then Worksheets(1).Activate: ActiveWindow.DisplayWorkbookTabs = False
If un = “Sal” Then Worksheets(5).Activate: ActiveWindow.DisplayWorkbookTabs = False
End Sub

Tools/Import and Export/Export to a file
Select Comma Separated Values (Windows)
Select folder to export from….
For ease just use the default values and save as C:contacts.csv

Importing is fairly straighforward following the above and does actually work.

Note: Unless you have a need to, it is not worth playing with the ‘mapping fields’ option – stick with the default. If you do on the export side, you will have to match it on the import side.

HTH

Tools/macros/Security will allow you to disable the warning by default – if that is what you want ?

Otherwise,
You may have deleted the macro but left the module which probably makes Excel believe there is a macro in the worksheet.
From the VB Editor, in the project viewer, select the Module (probably Module1) then go File/Remove Module1.

Grasping at straws now:

Control Panel/Multimedia:-
Does the CD player look like it features in all the right places?

Start/Programs/Accessories/Multimedia:-
Does the audio CD player have a manual start and/or do anything?

Using Word2K and working here:
View/Web layout
Format/Background and select a colour
Prints out on a B&W laser as Black on White but you may have to tweak the printer settings if it’s a colour jobbie.

I believe there is a registry tweak for this but what may be more useful would be to add Woody’s PlaceBar available here to which you can add specific folders.
…and thanks, Woody – one of the best add-ons I’ve come across.

You have got your hard-wired audio link from CD to sound card fitted OK ? (I think some cards have two ‘internal’ inputs).

Apparently Active Desktop did not come with IE5, only IE4 SP2 (not exactly sure of the SP). Looks like you need to uninstall IE5, install IE4, then re-install IE5
Check the threads here and here for the source of this info. HTH

Are you exporting as a CSV? If so, formatting should not come into it.
From memory, export as a CSV then import using the Comma Separated Values (Windows) option.

Try:
If the folder doesn’t exist, create it
Regedit:
HYEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionExplorerUser Shell Folders and rename the value of My Pictures to the folder you want.
At least, from Word, you won’t default to My Pictures for inserting a picture.

(Likewise: I refuse to have My Anything on any PC here)

If you run the set-up I believe you are offered a ‘Repair’ option. Might be worth running that.
Do you have W2K SP1 installed?

…then I fear Ghost or a backup may be your only option.
I assume you wanting to make your system partition bigger rather than a logical drive? Otherwise it may be just as cheap to buy another HD.

Thanks from me too.
I must play around with your suggestion.