Oops

I think you try to change the VBA in 97 now
Unprotect the VBA in a higher version of Excel

Then change the code and set the protection again in Excel 97
Now you can unlock your project in every Excel version




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Ok

Open the file in Excel 97 and remove the password


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"GypsyHarper" wrote in message ...
Nope, doesn't ask for a password. It just says project locked. I think the
file was brought over into Excel from an older version of Access at one
point. Maybe that has something to do with it?

"Ron de Bruin" wrote:

I think your VBA project is password protected

Does it ask you for a password ?



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"GypsyHarper" wrote in message
...
Yes, I see the project explorer. The project has no folders underneath it -
it's not just collapsed. There's no plus sign, and when I double click on
the project is says it's locked.

"Ron de Bruin" wrote:

the "ThisWorkbook" icon does not appear,

???

If you not see it see this page
http://www.rondebruin.nl/code.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"GypsyHarper" wrote in message
...
The code worked splendidly in my test file. But when I went to put it in the
file I actually want to use it in, the "ThisWorkbook" icon does not appear,
even after I saved a copy as a Macro Enabled file (I'm using Excel 2007, by
the by). Any ideas?

"Ron de Bruin" wrote:

Hi GypsyHarper

See
http://www.rondebruin.nl/print.htm#Last


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"GypsyHarper" wrote in message
...
I would like to enter a date in the header (or footer) of my Excel
spreadsheet. However, I want it to be the date the file was last saved, not
today's date. Is there a way to do this?