98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Worksheet protection error
Worksheet protection error
Resolved · Low Priority · Version 2003
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.
Mon 22 Aug 2011, 11:45Trainer Anthony said...
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.
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. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
