Posted to microsoft.public.excel.programming

external usenet poster

Posts: 21

Detecting active customview

Hello

I have to create a piece of code wich makes a few buttons visible or in
visible depending of te active customview that is selected on a sheet.It has
to be something like this:

Private Sub Worksheet_Activate()
If (ACTIVECUSTOMVIEW = view1) then
CommandButton1.Visible = False
End If

If (ACTIVECUSTOMVIEW = view2) then
CommandButton1.Visible = True
End If
End Sub

Thanks in advance...

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
Row select mode to highlight active row of active cell	Bart Fay[_2_]	Excel Discussion (Misc queries)	0	May 11th 10 09:34 PM
Detecting active customview	Bart	Excel Discussion (Misc queries)	1	December 15th 04 11:24 AM
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE.	ragman10	Excel Discussion (Misc queries)	1	December 13th 04 11:52 PM
script detecting the change of active cell	Jack	Excel Programming	1	February 12th 04 01:59 AM

All times are GMT +1. The time now is 05:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us