ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change the level of protections (MAKRA) (https://www.excelbanter.com/excel-programming/348393-change-level-protections-makra.html)

And1

Change the level of protections (MAKRA)
 
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

Change the level of protections (MAKRA)
 
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


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com