Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Currently I have a vba code that will eliminate the page after it has been
opened a number of times. For instacne if the code is set to 3, after the 3rd time the sheet is opened it will lock the user out permanently. However, if they should to select disable macros, they can access the sheet. How can you lock them out permanently. below is the code I am using. Private Sub Workbook_Open() Dim OpenCount As Integer OpenCount = GetSetting("MyApp", "Count", "OpenCount", 0) SaveSetting "MyApp", "Count", "OpenCount", OpenCount + 1 If OpenCount = 3 Then ThisWorkbook.Close SaveChanges:=False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row Deletion | Excel Programming | |||
name deletion | Excel Discussion (Misc queries) | |||
dup value deletion | Excel Programming | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
Implant macro coding into ASP coding | Excel Programming |