Disappearing command button

[ernie37]

I have a command button on a sheet that tends to appear and disappear between the workbook being saved and then reloaded. There are no hidden columns or rows on this page. I cannot detect a sequence of events that could cause this. Any ideas?

 

[ernie37]

ps It appears that some rows act like they are hidden. If I go to unhide rows, the button comes back. So now the question is, how do you do an ActiveX command to unhide all rows and columns on a page when the page is loaded???

 

[ernie37]

ps It appears that some rows act like they are hidden. If I go to unhide rows, the button comes back. So now the question is, how do you do an ActiveX command to unhide all rows and columns on a page when the page is loaded???

SOLVED I seem to have solved this by putting in a Private Sub Workbook_Open() macro in that contains a statement that unhides the macros on the sheet with the problem. So far so good.