Toggle Macro on Button

[Baziwan]

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]

Toggle it to do what?

[Baziwan]

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]

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]

Why not do it all at once?

[royUK]

Add a button from the Controls ToolBox then use this code

Please Login or Register  to view this content.

[foxguy]

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]

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