Wayne has attended:
Access Introduction course
Excel Intermediate course
Excel Advanced course
Worksheet protection error
We have an Excel spreadsheet in place at my employment that is used as a Holiday Diary. It is not password protected and the worksheet is not protected either.
When you choose the option to save (via the toolbar icon and not "save as") a system generated message appears stating "You have not protected the holiday chart. You should ensure that it is always protected so that only authorised users can make changes to the chart".
This message appears twice, appearing again after selecting "OK" on the previous instance.
This would not normally be a problem but it can cause the spreadsheet to save itself as a temp document in the same location with a file name such as C82DE300.
Is there anything that can be unchecked or removed so that this message does not appear, and hopefully the spreadsheet will save normally?
There are macros in place, but the original developer of the spreadsheet no longer works here.
Many thanks.
RE: Worksheet protection error
Hi Wayne, thanks for your query. That sounds a lot like there is some code attached to the Save event of the Worksheet which is checking to see whether the file has been protected or not and saving accordingly. You could disable the macros (via Tools - Macros - Security) but really this needs someone to have a look behind the scenes at what that code is doing.
Hope this helps,
Anthony
