Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Readonly
What i require is quite simple.
I have created a macro which extracts data from specfic spreadsheets The spreadsheets are in constant use and i there need to know th following: If the macro automatcly opens the spreadsheet and no one else is usin it it will open normally, but if the macro opens the file and it is i the read only box appears will the macro just go in as read only o will i have to place code to tell the macro to go in as readonly? If i require code can you please give an exampl -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Readonly
Should just open it readonly.
-- Regards, Tom Ogilvy "pauluk " wrote in message ... What i require is quite simple. I have created a macro which extracts data from specfic spreadsheets. The spreadsheets are in constant use and i there need to know the following: If the macro automatcly opens the spreadsheet and no one else is using it it will open normally, but if the macro opens the file and it is in the read only box appears will the macro just go in as read only or will i have to place code to tell the macro to go in as readonly? If i require code can you please give an example --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Readonly files | Excel Discussion (Misc queries) | |||
Making cells readonly | Excel Programming | |||
Open As Readonly | Excel Programming | |||
Closing ReadOnly file using VBA | Excel Programming | |||
Change ReadOnly State | Excel Programming |