-
-
Hi Ken,
Mr. Blood doesn't create the menu with code, he manually created it. Do so by right clicking any blank area on a menu bar, select Customize. On the Commands tab, scroll down the left side and select New Menu. Then on the right side, click and drag that New Menu (shaded grey by default) to any menu bar. Do so with toolbars the same.
As for any headers not moving, it didn't come that way with my download. But to freeze a set of rows and not have them move at all, say the top three rows, select the entire row of row 4. Do this by left clicking the '4' on the row headings, or select any cell in row 4 and press Shift + Spacebar (shortcut key). Then go to the Window menu, select Freeze Panes. You can do this with columns also. Play around with it.
-
The toolbar was created manually and attached to the workbook. So it is saved with the workbook.
The panes are frozen so it looks like there is a header. Window | Freeze Panes
-
Thanks guys. I follow the freezing panes now ... simple enough.
OK ... I played around with the toolbar customization stuff and figured out how the button is linked to a macro. That's a pretty slick trick.
Thanks for pointing me in the right direction!
Ken
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules