Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If a Workbook is already open?
Hi
I have a macro that opens a workbook for the user to modify. However, I need to stop the user from opening the workbook for a second time. I have used the normal read only attribute which works to a degree, but if the user chooses "No" I get an error in the macro. Also I don't want the user to be able to say "Yes" and loose all the modifications made by opening the workbook again. -- Kind Regards Mick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) |