Floating command button?

[Thrava]

Hi group,
Hope everyone is well.

I have a command button (click event driven that selects a
different sheet).

Is is possible to have the command button remain in the
same location eventhough the sheet is scrolled up/down or
left/right?

thanks everyone

 

[Bob Phillips]

Add a button to the toolbar and assign the macro to that

or

Freeze Panes below the button

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Thrava]

Bob,
Thank you for this tip.
Thrava

-----Original Message-----
Add a button to the toolbar and assign the macro to that

or

Freeze Panes below the button

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.