Prevent user from opening same workbook twice

[dcoledc]

I have created a fairly involved workbook. Well, fairly involved for me. If I have it open, but minimized, and then try to reopen, it causes lots of problems. I am wondering if there is some way to prevent the second instances from every opening.

 

[jeffreybrown]

Might this help...

http://www.ozgrid.com/VBA/IsWorkbookOpen.htm

 

[dcoledc]

I don't think that is what I am looking for. If the workbook is already open and the user clicks on the icon to open again, it causes trouble.

Any more thoughts? Or do I misunderstand the use of the code?

 

[jeffreybrown]

Hi Dan,

I can't seem to find something to keep the same workbook from opening other than the user clicking No when Excel warns them the workbook is already open.

Maybe somebody else will step in with an idea...

 

[dcoledc]

Thanks for checking.

 

[xenou]

I have created a fairly involved workbook. Well, fairly involved for me. If I have it open, but minimized, and then try to reopen, it causes lots of problems.

This is a curious case. What kind of problems? Why aren't your user's able to just say "no" when the message pops up? Why don't they even know they already have the workbook open? I'd probably shoot myself if I had to work with users like this ... best to keep them away from your workbooks.

 

[Jaafar Tribak]

Hi Dan,

I can't seem to find something to keep the same workbook from opening other than the user clicking No when Excel warns them the workbook is already open.

Maybe somebody else will step in with an idea...

The only thing I can think of is to use a windows hook or a background timer to automatically dismiss the excel warning.