Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear experts,
I have a workbook containing macros which I would like to open as read-only on certain days. E.g.: If Day(Now) 9 And Day(Now) < 17 Then 'OPEN WORKBOOK AS READ ONLY msgbox ("You can only access this spreadsheet between the 17th of the month and the 8th of the following month") Else 'OPEN WORKBOOK NORMALLY End If Is this possible? what would be the code for it? And would my macros still work? Thanks! Kind regards -- Valeria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening Workbook as Read Only and using ".Activate" | Excel Programming | |||
Opening workbook automatically as Read-0nly | Excel Programming | |||
opening workbook as read-only or write-enabled | Excel Programming | |||
opening workbook as read-only | Excel Programming | |||
Opening Excel Workbook from Word using VBA - Always Read Only | Excel Programming |