MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sheet is already open? can't run macro.

Posted by Qroozn on October 16, 2001 3:27 PM

when i attempt to run a macro in an excel sheet it tells me that the worksheet is already open.
When i check the macro list then it shows the full file path rather than the name of the file.

Why does it keep on doing this every hjnow and again? can i get around it?

Posted by Riki Phelan on October 16, 2001 6:55 PM

I had this problem recently. Did you copy the file to another directory as I did?

Anyhow, the solution - re-assign your macro/s to the option button/s that you have these macro/s attached.

Cheers, Riki