Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Hamish Jones   on Nov 15 In MS Office Category.

  
Question Answered By: Alexis Castillo   on Nov 15

Let's find out:
with that sheet  the active sheet:
press Alt+F11 to open the vbe  (visual basic editor)
Make sure the immediate window's open with Ctrl+G (or View|Immediate
Window)
then type the following line in that pane followed by [Enter]:
?activesheet.shapes.count
if the result's not zero then enter the next line folllowed by
[Enter]:
for each shp in activesheet.shapes:?shp.name:next

You might get something like this:
CommandButton1
CommandButton2
CommandButton3
Button 29

in which case you've got some buttons on the sheet but not visible.
Come back  with what you get and we'll take it from there.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Ghost Hand on my worksheet Or get search suggestion and latest updates.


Tagged: