Assign code to Toolbar Created in VB to Hide Sheets and then Rehide

**Simon Austin** · 01-22-2009, 07:28 AM

Hi All.

I have code which creates a tool bar which works Ok, however I can't get the statement correct to assign code to it.

Please Login or Register  to view this content.

This is the code that I want to assign to the toolbar:

Please Login or Register  to view this content.

All help welcomed!

Thanks

Simon

**Andy Pope** · 01-22-2009, 07:36 AM

Your code works for me.

What do you think is not working?

**davesexcel** · 01-22-2009, 07:46 AM

Isn't the on action part of the code where you call the macro?
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

**Simon Austin** · 01-22-2009, 10:15 AM

Hi Andy.

Each piece of code works Ok in it's own right however I'm having trouble calling the hide/unhide code from the tool bar. I'll amend with the OnAction property (Thanks Dave) and get back to you. Thanks for your time.

Simon

**Andy Pope** · 01-22-2009, 10:26 AM

As I say worked fine for me.
Created the toolbar and buttons. Each button executed the correct routine.

Try adding a msgbox statement to the beginning of each routine so you can see whether it really does run the code or not.

Please Login or Register  to view this content.

**Simon Austin** · 01-23-2009, 05:05 AM

All sorted now thanks all.

**Andy Pope** · 01-23-2009, 08:16 AM

Care to share what you needed to do in order for it to work?

**Simon Austin** · 01-23-2009, 08:54 AM

Hi andy.

I was making the error of trying to do it all in a single module. I added the second piece of code to a separate module and hey presto...

Thanks for your time.

Simon

**Andy Pope** · 01-23-2009, 09:10 AM

Thanks for the update.

Assign code to Toolbar Created in VB to Hide Sheets and then Rehide

LinkBack

Thread Tools

Rate This Thread

Display

Assign code to Toolbar Created in VB to Hide Sheets and then Rehide

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions