Toggle Macro on Button

**Baziwan** · 07-03-2010, 01:00 PM

Hi Guys,

How can I toggle this macro on a button click?

Please Login or Register  to view this content.

Thanks in advance

**Bob Phillips** · 07-03-2010, 01:05 PM

Toggle it to do what?

**Baziwan** · 07-03-2010, 01:08 PM

Originally Posted by Bob Phillips

Toggle it to do what?

When you click the button the first time it unprotects the sheet and converts the list to range.
What I want is that when you click the button again, it adds the list and protects the sheet.

**foxguy** · 07-04-2010, 05:36 PM

Hi Baziwan;

I don't know anything about ListObjects. I'm going to try and learn about them.
But something like this should do what you want.

Please Login or Register  to view this content.

I would really like to see the finished macro, so when you have fixed mine, please post it back here.

**davesexcel** · 07-04-2010, 05:52 PM

Why not do it all at once?

**royUK** · 07-05-2010, 01:39 AM

Add a button from the Controls ToolBox then use this code

Please Login or Register  to view this content.

**foxguy** · 07-05-2010, 12:49 PM

Hi Roy;
I really like your idea of changing the caption on the Button.
What's the purpose of this line?

Please Login or Register  to view this content.

I'm using XL2002, so I don't have ListObjects, but I'd like to know why you hide it.

**royUK** · 07-05-2010, 01:08 PM

That line switches off the List Toolbar, it's not essential.

Toggle Macro on Button

LinkBack

Thread Tools

Rate This Thread

Display

Toggle Macro on Button

Re: Toggle Macro on Button

Re: Toggle Macro on Button

Re: Toggle Macro on Button

Re: Toggle Macro on Button

Re: Toggle Macro on Button

Re: Toggle Macro on Button

Re: Toggle Macro on Button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions