LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Saving a Workbook where the worksheets are protected

Hello. I have an Excel template (.xlt) that has approximately 5 worksheets.
Each worksheet has locked cells and the worksheets are protected for those
cells. We have recently updated our Microsoft definitions (SP) and now get
the following message when attempting to save the template as an Excel (.xls)
file:

The cell or chart you are trying to change is protected and therefore
read-only.
To modify a protected cell or chart, first remove protection using the
Unprotect Sheet command (Tools menu Protection submenu). You may be prompted
for a password.

You choose OK and it saves the file without making the Protection change.

I would like to get rid of the message (alot of users are getting confused
when they receive this message and then it saves anyway when they choose OK)
It used to work ok before we upgraded. Any help is most appreciated.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protected worksheets Nell Excel Discussion (Misc queries) 1 May 30th 06 12:17 PM
Preventing other users saving another version of protected workboo Laura Cook Excel Discussion (Misc queries) 1 August 5th 05 06:53 PM
Protected Worksheets Nikki Patel Excel Worksheet Functions 0 April 22nd 05 08:49 PM
Saving worksheets Tkaminski Excel Worksheet Functions 1 April 18th 05 03:49 PM
Multiple workbook user's with Master workbook - all password protected Yvon Excel Discussion (Misc queries) 2 March 30th 05 01:34 PM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"