Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can I interfere in setting of protections (the level of protections -
MAKRA)?? can I get information about current settings (low, high,...) can I change the level of protections in event: Private Sub Workbook_Open() "If level of protections =High then Set level of protections =Low end if" ' and ??? thisworkbook.close savechanges:=true End Sub Kind Regards, Andrzej |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If any code could change the level of protection, then it really wouldn't be
much protection. This is one of those things that users have to change for themselves. With macros disabled, there's nothing that will make your macro even start. And1 wrote: Can I interfere in setting of protections (the level of protections - MAKRA)?? can I get information about current settings (low, high,...) can I change the level of protections in event: Private Sub Workbook_Open() "If level of protections =High then Set level of protections =Low end if" ' and ??? thisworkbook.close savechanges:=true End Sub Kind Regards, Andrzej -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I change the level of an individual in Excel Org chart? | Charts and Charting in Excel | |||
It's posible to change security level from VBA? | Excel Programming | |||
Using VBA to change macro security level | Excel Programming | |||
Security Level wont change... | Excel Programming | |||
Macro to change security level | Excel Programming |