hide & unhide toggle button

Posted to microsoft.public.excel.programming

Ben McClave Ben McClave is offline

external usenet poster

Posts: 173

hide & unhide toggle button

Hello,

I'd try just one small change to the line below:

Range("B" & myRow & ":" & myAdr).EntireColumn.Hidden = Not Columns("B").Hidden

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hide/Unhide Toggle	BEEJAY	Excel Programming	3	July 17th 08 08:32 PM
Toggle Button in Ribbon to Hide/Show Built-in Tabs	Don[_30_]	Excel Programming	0	March 27th 08 12:17 PM
using a toggle button to show or hide information in several cells	hanson	Excel Worksheet Functions	3	December 7th 07 10:16 PM
HOW CAN I HAVE THE SHEET TO BE PROTECTED, FORMULAS HIDDEN AND YET GIVE AN OPTION IN VB TO HAVE A TOGGLE TO PROTECT/ UNPROTECT/HIDE/UNHIDE CELLS	CAPTGNVR	Excel Programming	0	February 17th 07 11:13 AM
Syntax of hide/unhide personal.xls toggle	mikeburg[_32_]	Excel Programming	2	September 24th 05 01:24 AM

All times are GMT +1. The time now is 12:21 PM.

About Us