Excel Freeze Panes For Menu

[JohnEOasis]

I have googled and searched Tek-Tips and can not find the answer so I thought I would post my question.

I created a menu in Excel with shapes and I need the menu not to move either vertically or horizontally when the user sctolls. To complicate things I have a header row that is frozoen as well that does need to scroll horizontally but not vertically. Any suggestions would be appreciated.

 

[SkipVought]

Hi,

Put your menu in a UserForm.

Forum707 for help.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[JohnEOasis]

Thank you for your reply. I added a user form and got it to load when the workbook opens; however this keeps the user from accessing the sheet while the menu is open. Is there a way around this with out haveing to close and reopen the menu everytime?

 

[SkipVought]

YourUserForm.Show vbModeless

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[JohnEOasis]

Thank you.