Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Richard Buttrey
 
Posts: n/a
Default

Hi Roger,

Thanks for that.

I've certainly got the extra toolbar although I'm still slightly
puzzled.

The original VB toolbar has the Run, Record, Security, VB Editor,
Control Toolbox, Design Mode and MS Script Editor icons.

This new one has the Record Macro and Relative Reference icon. However
the Record Macro is greyed out and inoperative.

The Relative Reference icon is correctly acting as a toggle but I
have to use the Record icon from the original toolbar.

Non of this is a particular problem, but I'm just wondering why the
icons aren't combined in one toolbar.

Rgds






On Thu, 13 Oct 2005 13:09:43 +0100, Roger Govier
wrote:

Hi Richard

From a posting by Bernie Dietrich

Sub MakeToolbarVisible()
With Application.CommandBars("Stop Recording")
.Visible = True
.Enabled = True
End With
End Sub

If you close the toolbat with the "X" button, whilst recording a macro
it disappears.
Stop recording the macro with STOP and not "X"

Regards

Roger Govier


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Recording new excel macro, relative reference button doesn't show Dano New Users to Excel 3 August 23rd 05 07:36 PM
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 06:04 PM
How do I keep an Excel macro that gets transferred to Pocket Excel Holdfast Excel Discussion (Misc queries) 1 July 23rd 05 11:14 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"