Toolbars Lost After Macros Used

May 30, 2006

A IT Ordering system has been created using Excel, I am prompted to enable Macros, no problem there. The problem is that when I exit the worksheet using a formulas setup as an exit button, my Excel is displayed with my Toolbars missing. I have been unable right-click at the top and re-add these I am only presented with the option to minimise, close etc. 1. How can I replace my Toolbars? 2. Is there a formula fix so that I can use this worksheet without losing my toolbars?

View 3 Replies


ADVERTISEMENT

Excel 2003 :: Lost Menu / Toolbars And Scroll Bars In All Workbooks

Nov 18, 2011

I was working on an Excel 2003 workbook with 3 worksheets. The first sheet is the 'Menu' sheet on which I placed buttons to take me to the other two sheets and back. I wanted to hide the Excel menus, toolbars, scrollbars, etc. on the 'Menu' sheet so that no user can alter that 'Menu' sheet. The 'hiding' code was not meant to affect the other two sheets.

The code worked fine. However, when I closed the workbook and tried to open a NEW workbook so that I could do some other work, I realised that the new workbook and its accompanying sheets had the menus, toolbars, scroll bars, etc. hidden. I closed the workbook and tried opening a new workbook. It was the same experience.

I called up the file with the code, deleted all the codes attached to that file, and re-saved the file. It did not solve the problem. And when I tried many more new workbooks and got the same problem, I deleted my entire Office 2003 installation and re-installed Office 2003. It still did not solve the problem.

View 9 Replies View Related

Exporting Crystal Report: Macros Being Lost

Oct 5, 2006

I have been able to export data from a Crystal Report into an Excel file. After exporting to the Excel file I copy a Macro that I wrote into the workbook that deletes blank lines. My question is: Is it possible to export into a workbook that contains macros without overwritting the entire workbook which wipes out the macros?

View 4 Replies View Related

Toolbars And Add-ins

Jul 20, 2006

I created a custom toolbar in excel. by right clicking on the toolbar, creating new, adding a couple buttons and assigning them to a couple macros.

I'd like to send this to people, how do i do this.
Obviously, the toobars's would have to reference the macros, these i have in an add-in.

Is there anyway that i could attach the toolbar's to the add-in so i could just send the add-in.

I also created a menu, is there anyway that i can put this into the Add-in also?

Where does the toolbar i created and the menu that i created save down. If i open a new excel without opening personal.xls, the toolbars will still be there (open one excel, then open another and it tells me that my personal.xls is in use by jason harris, i hit cancel so it opens without my personal workbook)

Lastly, if I open excel, then go into VB, I can save my personal workbook. How do I save this as or save a copy?

View 9 Replies View Related

Commands And Toolbars Gone

Jan 30, 2008

I lost my command bar and tool bars (excel 97) all I have is the blue bar on top then the column letters. How do I restore them?

View 9 Replies View Related

Resetting Toolbars

May 29, 2009

my excel is no longer showing any tool bars and I can not get them back, is there any short cuts to bring back the menus? I can’t even do a right mouse click on the sells for some reason. The only tool bar that is showing is the formula bar.

View 10 Replies View Related

Remove The Toolbars

Mar 27, 2008

I have a slight problem with some code I am using. I have a user form where I force the users to enable Macros using the hidden sheets trick. Once the user enables the macros all of the toolbars dissapear from excel. The code I use to do this is below:

View 14 Replies View Related

Can I Automate Toolbars

Oct 27, 2006

I find that the picture toolbar opening automatically when I click on a picture useful (sometimes).

Is there anyway of automating other toolbars to open (such as 'chart') when I click on an object?

I've been looking at various add-ins in google - but can't find one to do that.

View 9 Replies View Related

Saving My Toolbars

Jul 26, 2006

Everytime this meant that I had to start from scratch in order to have my customized toolbars. This is a bit inconvenient.

Can I simply save some file (containing my XL toolbar settings) from some location and if I ever run into such a situation again, I can simply copy the saved file back into the same folder...

Thanks in advance for your help and BTW would the solution work the same way for different Excel versions or?? My O/S is XP and I use both Excel 2003 (once in a while I also use Excel 97 but that is installed on my other old pc).

View 3 Replies View Related

Macro To Hide All Toolbars

May 22, 2009

I am looking for a macro to hide all toolbars i am using this at the moment

View 4 Replies View Related

Toolbars Empty Nubs

Sep 15, 2006

I use excel 2003 and have maybe 60-70 macros linked to buttons on maybe 6 custom toolbars. The macros are saved on a personal.xls that is saved in the XLStart folder so it will auto start every time I run excel. My excel crashed and my toolbars are all empty nubs and my personal.xls is still in the same folder but does not auto start...did a detect and repair no help...I manually started personal.xls no help...I found a thread that suggested looking for *.xlb didn't find it...a shared file with the same toolbars can be seen by other computers but not mine...

View 6 Replies View Related

Remove/Show All Toolbars

Oct 4, 2006

I want a code that removes all toolbars from excel when the .xls file is opened, then restores all toolbars back to their original setting when the .xls file is closed.

View 9 Replies View Related

Hide Toolbars In Workbook

Sep 13, 2007

I ONLY want to show the status bar, worksheet tabs, horizontal and vertical scroll bars.
I've tried using the code below but the column and row headings will not show on the first sheet i bring up, but it reappears on other sheets. everything else works fine ....

View 3 Replies View Related

Remove Title Bar & Toolbars

Dec 29, 2007

is there any way that i can remove the excel title bar and scrolling tabs so that the excel sheet do not resemble an excel document?

View 2 Replies View Related

Put Toolbars Back On Workbook Close

Mar 2, 2007

This code snippet works when executed from a worksheet (it puts Menu Bar back) but returns an error when used in the This Workbook module.

Application.CommandBars("Worksheet Menu Bar").Enabled = True
CommandBars("ToolBar List").Enabled = True
CommandBars("Ply").Enabled = True

View 4 Replies View Related

Hide Toolbars & Restore Visibility

Aug 13, 2007

I have a procedure that stores the Commandbar names and visibility settings in an array on open. Another procedure hides all Commandbars on open and restores their original visibility settings on close. For some reason the "Standard" and " Formatting" toolbars don't return to visible on close.

My error log says "08/13/07 18:21:37 [QA.xls]MCommandBars.bRemoveMenus(), Error -2147467259: Method 'Visible' of object 'CommandBar' failed". I have tried manually testing the hide/unhide procedure with hard coded settings and checked the correct variables are being sent and all seems to be correct.

I am pretty confident that the procedure to store settings is correct but have included the code just in case, also just noticed the "Standard" and "Formatting" toolbars are the only two visible at programme start.

Public gsaMenus() As String

Public Function bMenuSettings() As Boolean

Const sSOURCE As String = "bMenuSettings()"

Dim bReturn As Boolean
Dim iCounter As Integer
Dim cbrMenu As office.CommandBar

View 9 Replies View Related

Prevent Customization Of Menus And Toolbars

Nov 20, 2007

I have a custom toolbar created in a workbook. I have coded my workbook so that the full screen is displayed, removing the title bars, status bars etc

Application.DisplayFullScreen = True

However, there is still another menu option I am not able to remove. It is the "Add or Remove Buttons" and when you click that the "Customize..." button also is enabled.

I looked up some code on microsoft and only found code in office97 that gave me errors in 2003:

Sub DisableCustomize()
Application.CommandBars("Tools").Controls("&Customize...").Delete
CommandBars("Toolbar List").Enabled = False
End Sub

The quote from the site says "To prevent others from changing the menus and toolbars in a custom application, remove or turn off the Customize option on the Tools menu and turn off the Toolbar List shortcut menu."

I get an error saying invalid procedure when I run that.

how to disable the button or prevent users from choosing it?

View 9 Replies View Related

Extra Toolbars Have Appeared At Top And Left Of My Worksheet

Jul 19, 2009

I find (what look like) two extra toolbars have appeared at the top (below the standard and formatting toolbars) and to the left of my worksheet.

They have lines, dots and little boxes with an x or - in them, depending if you click on them or not. The +/- box function seems to be to make columns appear and disappear.

How did I turn this function on and more importantly, how do I turn it off?

View 4 Replies View Related

Custom Toolbars Visible In A Specific Workbook

Dec 30, 2008

I created 3 custom toolbars. I want toolbar A to be visible only in Workbook A.xls, toolbar B to be visible only in Workbook B.xls and toolbar C to be visible only in Workbook C.xls. while Workbooks A,B, and C are open at the same time. I use Workbook A to automatically open Workbooks B and C.

Problem: Since I'm openning the Workbooks automatically it only keeps the Toolbar C visible on all Woksheets.

I included the following code in the This Workbook Object on each Workbook:

For Workbook A:

Private Sub Workbook_Open()

Application.CommandBars("A").Visible = True
Application.CommandBars("B").Visible = False
Application.CommandBars("C").Visible = False

End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.CommandBars("A").Visible = False
Application.CommandBars("B").Visible = False
Application.CommandBars("C").Visible = False..............................

View 9 Replies View Related

Show/Hide Toolbars For Current Workbook Only

May 10, 2006

I have a macro that starts when the workbook is open that hides many of the headers and toolbars. It is great and works fine unless you are working on another workbook and need to see those headers and tool bars. Is there a way to display and hide those items per workbook and not for the entire application. here is my failed attempt:

Sub show_excel_headers()

Dim wb As Workbook
Set wb = ThisWorkbook

wb.Application. ScreenUpdating = False

'Display Headings in all worksheets
Dim wsSheet As Worksheet
Dim sSheetStart

Set sSheetStart = ActiveSheet

wb.Application.EnableEvents = False
For Each wsSheet In Worksheets
wsSheet.Activate
ActiveWindow.DisplayHeadings = True

View 9 Replies View Related

Hide Toolbars When Workbook Protection Is Enabled

Jun 26, 2006

I would like to hide the standard and formatting toolbars in excel when i enable workbook protection, however I have no idea how to get excel to realise when workbook protection has been enabled, and how to hide the toolbars in VBA also. Also i would like to know how to do the reverse (how to show tooldbars when workbook protection has been disabled)

View 3 Replies View Related

Remove Toolbars Upon Open/Re-instate Upon Close

Aug 19, 2006

Is it possible to use a function that removes all toolbars upon opening the workbook and reinstates the same upon closing, the work book i am currently using does the following as described in the code. however the function is limited in that only toolbars stated in the code will be removed, if for instance there was an adobe toolbar, that remains on the screen. or is there a better way of going about this? On open:

Private Sub Workbook_Open()
Run ("CreatePReturn")
Run ("CreateProceed")
With Application
.CommandBars(" Formatting").Visible = False
.CommandBars("Standard").Visible = False
.CommandBars("Drawing").Visible = False
.CommandBars("Return").Visible = False
.CommandBars("Proceed").Visible = False
.CommandBars("Worksheet Menu Bar").Enabled = False
.CommandBars(" Chart Menu Bar").Enabled = False
.DisplayFormulaBar = False
.DisplayStatusBar = False
End With
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With.................................

View 4 Replies View Related

Find Customised Toolbars File Path

Oct 2, 2006

In Windows 98 for example when you created a Customised Toolbar and attached macros to it a file was created with the user name followed by 8.

i.e. timbo8

You could copy this file and keep it was a backup in case you lost the toolbar/s. Which invariably happened whn someone else logged onto your pc. When the company transferred over to Windows 2000 this file was called something else I thing it ended in a .xla extension but I don't know what it was called or where it it located.

View 2 Replies View Related

Preventing Users Viewing Toolbars And Exiting Full Screen Mode?

Jul 12, 2014

I have created a spreadsheet and wanted to originally see if I could save as a separate format (that makes it more like an application than an Excel spreadsheet). Having investigated, I found that full screen mode pretty much does what I want, however you can restore the menus by pressing ESC or selecting restore down. Is there a way of preventing users from exiting full screen mode, I could add a close application button for them to use instead.

View 3 Replies View Related

Lost Formatting

Nov 9, 2008

I have a workbook that is used by others and has been working reasonably well for several years. The users are youngsters who tend to play with it when a bit bored but I usually manage to put things right. They seem to have done something special this time.

The formatting for dates, time and money has gone and I cannot correct it. I have tried the usual formatting of cells, painting formats from other sheets, copying and pasting formats all to no avail. The whole sheet is effected so that new entries appear the same way although the correct format appears in the formula bar.

I don't know if this is relevant but the sheet relies on VBA form inputs. The code is password protected and only I know the password.

The PC is not connect to the internet or a network so I have ruled out a virus. (As far as I know, no floppies or USB sticks have been used on it either.)

View 14 Replies View Related

Lost The Menus

Apr 3, 2009

Having recently started to get involved in Visual Basic I have managed to write some code that has removed all of my menus except for File and Help. In a blind panic I deleted what I think was the offending VB code in a vain attempt to return the menus. This didn't work. I am now stumped.

Also, I managed to change the way the Cell selection works when I press Return. When I press Return, Excel now selects the cell to the right of the one I was in rather than the one below it. Is there a way I can change this back?

View 5 Replies View Related

Formula Lost

Dec 3, 2006

I have been chasing this little devil for some time now and I'm fed up!!

I put a formula in cells formula bar and whenever it decides by itself poof its gone!!!

example formula would be say (in formula bar)

=SUMPRODUCT(--($A$5:$A$200>(h4/24)),--($A$5:$A$200<(h5/24)))

in say cell g31 with answer in cell 31.

Now it just dawn on me, this is an array correct so ctrol,shift, enter may be needed?? If so why do other cells with same idea work?

View 9 Replies View Related

Lost VBA Code

Jul 10, 2007

I just spent 8 hours of VBA coding completed and after exiting excel and re-opening the file, I have seem to lost all the 8 hours worth of VBA coding I just completed. For example, I created an extra module (Module 3) and that disappeared; I updated several SUB commands and even those did not update. My code was about accessing databases using the OpenDatabase method and I noticed that towards the end before I shut it, my connection to the database kept failing (hence the reason why I was closing it and reopening it).

View 3 Replies View Related

Lost On Multiple IF Functions?

Feb 27, 2014

I'm essentially trying to place a column that is largely based on another....a function that will calculate the following information

Carriers with 1 Vehicle - 25.00
Carriers with 2-4 Vehicles - 100.00
Carriers with 5-9 Vehicles - 200.00
Carriers with 10-24 vehicles - 400.00
Carriers with 25-49 vehicles - 750.00
Carriers with 50+ vehicles - 1500.00

In other words.

One column in my spreadsheet has number of vehicles. I want another column that will provide the according application fee as found in the information above.

View 13 Replies View Related

Lost Format After Pasting

Oct 11, 2007

I have two files: let's say File1 and File2.File1 has one column: datas are in a text format.I copy this column. I want to paste it in my second file.File2 is closed.I open it and i paste my column.
Here's my problem. If i let my first file opened, there's no problem(!!): my column is pasted as i want. My datas keep their original format.
But, if i close my first file and after, i open File2 and i paste my column, then my datas lose their original format.My column takes a numeric format.I can see it because my datas are on the left in the column.And i can chek it by a sum: if i do 400+200, for example, the result is 600. In the first case(text format), the result is 0.I don't understand why.If someone can explain me this situation, i'd be happy.I repeat: my second file is closed. I open it after my copy in the first file.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved