Forum home » Delegate support and help forum » Microsoft Excel Training and help » Worksheet protection error
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Worksheet protection error
Resolved · Low Priority · Version 2003
Reply Thu 18 Aug 2011, 14:43Delegate Wayne said...
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.
For upcoming training course dates see: Pricing & availability
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
Mon 29 Aug 2011: Automatically marked as resolved.
|