Mouse Over and Back Function in Excel
Hi Kaci,
See VBA help for 'CommandBars Collection Object', which, incidentally,
includes this example:
'============================================??
The following example creates a custom toolbar named "Custom1" and displays
it as a floating toolbar.
Set cbar1 = CommandBars.Add(Name:="Custom1", Position:=msoBarFloating)
cbar1.Visible = True
'<<==========================================
---
Regards,
Norman
"kaci" wrote in message
...
Hi Tom,
But how do i create a custom toolbar???
Cheers,
Kaci
"Tom Ogilvy" wrote:
for the second, create a custom toolbar and put a back button on it.
Undock the toolbar so it floats.
--
Regards,
Tom Ogilvy
"kaci" wrote in message
...
Hi all,
I have prepared a Index / Content worksheet in my excel file. In the
index
worksheet, whenever i double click the link, it will point me to the
corresponding Chart. I would like to upgrade as below, and seek for
expert
advice in the group.
1. I would like to have my pointer look like a 'hand' or a 'arrow'
when
the
mouse is over the link (before double clicking the link).
2. When the user is in the Chart, I would like to create a BACK button
which link the user back to the index page. Instead of creating a
BUTTON
at
every page, is there any way to do it? (Since I need this function in
every
worksheet or chart in my file).
Thanks for advice.
|