Problem when attempting to save Workbook with VBA project protected

[Friedrich Hofmann]

Hi folks,

may be I am too stupid to find the right google search arguments for my
problem.
Here goes:

EXCEL 97 Workbook on Windows 2000 prof. machine with VBA code in Module
1. Works as intended.

Now I hide the VBA code via VBA project properties and save ok.
Subsequent attempts to save the workbook will store it under a new
(random ?) filename without ".xls". An associated message will tell me
so as well as that the
file cannot be renamed and I should close this file.

What am I missing ?

Thanks in advance

 

[Tom Ogilvy]

When you open a file, excel makes a copy of it and assigns a name such as
you describe. When you save the file, the original is deleted and this copy
is renamed. It sounds like the renaming is being prevented on your machine.
This can be caused by virus software or network permissions or perhaps
something else.

 

[Friedrich Hofmann]

Tom Ogilvy wrote:
| When you open a file, excel makes a copy of it and assigns a name
| such as you describe. When you save the file, the original is
| deleted and this copy is renamed. It sounds like the renaming is
| being prevented on your machine. This can be caused by virus software
| or network permissions or perhaps something else.

Hi Tom,

thanks for the quick response, however problem persists with AV-software
deactivated and obviously no network permissions involved (file resides
on local drive). Same thing also on Win XP Notebook.

Any idea why this happens only with VBA Project Protection enabled and
not with VBA Project Protection disabled ?

Regards
Friedrich

 

[Tom Ogilvy]

do you have the Google desktop installed. I don't want to attribute every
anomaly to that, but there were some weird things it caused to happen in the
VBE. I don't recall specifically if this is one of them.

take a look here and see if you find anything familiar: (if you do have it
installed)

http://www.dicks-blog.com/archives/2004/12/11/google-desktop/

Other than that, nothing else comes to mind.

 

[Friedrich Hofmann]

Tom Ogilvy wrote:
| do you have the Google desktop installed. I don't want to attribute
| every anomaly to that, but there were some weird things it caused to
| happen in the VBE. I don't recall specifically if this is one of
| them.
|
| take a look here and see if you find anything familiar: (if you do
| have it installed)
|
| http://www.dicks-blog.com/archives/2004/12/11/google-desktop/
|
| Other than that, nothing else comes to mind.

Tom,

the problem went away after saving the file as an Excel Worksheet rather
than an Excel 97 Worksheet under a different file name. Obviously
another one of those MS mysteries.

Thank you for your assistance
Friedrich