LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 127
Default opening a workbook as read only

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
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
Opening Workbook as Read Only and using ".Activate" John Brenner Excel Programming 2 January 13th 09 05:26 PM
Opening workbook automatically as Read-0nly excelnut1954 Excel Programming 5 May 3rd 06 06:43 PM
opening workbook as read-only or write-enabled archiboy Excel Programming 1 January 31st 06 01:11 PM
opening workbook as read-only Mariusz Excel Programming 2 May 25th 04 08:53 AM
Opening Excel Workbook from Word using VBA - Always Read Only Alan Excel Programming 0 November 5th 03 02:55 AM


All times are GMT +1. The time now is 04:20 AM.

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"