Spreadsheet hanging using Go to worksheet

Post Reply
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Spreadsheet hanging using Go to worksheet

Post by paulsimon »

Hi

As this had me stumped for quite a while I thought I would share it.

I had a spreadsheet with an Action Button that was using Go to Worksheet. It wasn't actually going to another worksheet, but was just using the option to copy data from one cell into a named range on the same sheet. Therefore, I left the Action Button's target workbook and sheet properties blank.

This was working fine on two other workbooks. However, on a third workbook, whenever I clicked the Action Button, Excel displayed Not Responding and the only way out was to terminate Excel.

The sheet had two Active Forms on it. I am not sure if that is significant.

The only thing that I could think of that was different between this workbook and the two others, was that I had changed the name of the sheet. My guess was that the Action button had somehow recorded the original name of the sheet inside itself and was trying to go a sheet that didn't exist.

The solution was to change the Action Button properties, still leaving the Workbook property blank, but to put in the new name in the target Sheet property. After that it worked correctly.

Regards

Paul Simon
Post Reply