LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Macro - settings to protect sheets

Great... once I had posted the question, I found the answer:

from: http://www.excelforum.com/showthread...hreadid=382012

According to VBA, the choices for ActiveSheet.PROTECT a

expression.Protect(Password, DrawingObjects, Contents, Scenarios,
UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns,
AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows,
AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows,
AllowSorting, AllowFiltering, AllowUsingPivotTables)

To prevent users from selecting protected cells,
"ActiveSheet.EnableSelection = xlUnlockedCells" has to be set additionally...
(however, some more problems occur here as this function is - unlike the
manual setting - not persistent when performed via code.

So, sorry for bothering the community ;-).
Cheers,
Philipp
 
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
Macro to Protect Mult Sheets / but allow Pivot Tables... Chris Excel Worksheet Functions 0 November 13th 08 06:37 PM
Macro to protect multiple sheets? Stilla Excel Worksheet Functions 12 March 5th 07 07:03 PM
Use Macro to protect choosen sheets in workbook kevhatch Excel Discussion (Misc queries) 1 January 27th 07 06:52 PM
macro to copy all print settings to all sheets rbanks[_17_] Excel Programming 3 March 14th 06 05:06 PM
Protect sheets from editing but allowing macro to do so? NooK[_52_] Excel Programming 5 August 5th 04 03:55 PM


All times are GMT +1. The time now is 10:07 PM.

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"