Excel 2010 :: Using Macros As Navigation Tool?

Feb 3, 2013

I have a 'dashboard' worksheet in 2010 and want to be able to click on a cell in this sheet and have it take me to the assigned worksheet. They are all in the same workbook. e.g if i click on Leadership i want it to take me to the Leadership tab, Skills to take me to the Skills tab etc The 'dashboard' will be the only viewable sheet in the workbook until one of the items on the page has been clicked.

I have a very basic understanding of macros and I'm not sure if this would work or if i should use a formula instead?

View 1 Replies


ADVERTISEMENT

How To Implement Permanent Macros Inside Of Excel As Tool

Aug 1, 2013

I have a macros, which i dont know when i will need to use them.

I need somehow inbuild them into excel to be able use them in every excel start.

View 3 Replies View Related

Excel 2010 :: Saving Camera Tool Snapshot?

Jun 18, 2013

In Excel 2010, I used the camera tool to take a snapshot of a selction of cells. How do I save the snapshot only as a JPG or GIF file?

I know that there are programs outside of Excel that can take snapshots or print screens, but I need to accomplish it using the camera tool so the snapshot is the exact selection everytime. Is the excel snapshot temporarily saved somewhere on my computer where I can access it?

View 1 Replies View Related

Menu Bar/Navigation :: Tool That Creates A Menu Bar Or Code?

Oct 20, 2009

I have a workbook with multiple sheets. Is there a tool that creates a menu bar or code that I can add that would support navigation?

My goal is to have something with approximately 4 options (buttons?). They would link to 4 different sheets that serve as indexes within the workbook.

I know I can add a control like a button to a given sheet that would take the user to given sheet when clicked, but can I make the button 'float' above all the sheets, or add to a menu bar, or something? I just don't want to have to add the button to every sheet in the workbook.

I am looking for something simple/easy, and am not looking for anybody to do the work. I just have no idea on how to approach the problem.

View 11 Replies View Related

Creating Custom Tool Bar For Macros In Workbook

Jan 6, 2013

I want to create a custom tool bar for a work book but when I right click in the unused part of the tool bar area the only options I get are customize Quick access tool bar and customize the ribbon.

View 3 Replies View Related

Excel 2010 :: Macros Not Working In Windows 7

Apr 29, 2014

I have a macro to collate data from multiple workbooks to a single sheet. The folder path to the source files can be chosen thorugh the macro. It runs perfectly in my system running on Windows XP. But it doesnt run on Wondows 7 system. Both are using MS Excel 2010. In Windows 7 system, while choosing the folder path where source files are located, it says "No items match your search" (screenshot attached). I would want the macro modified so that it runs on any platform. The macros that I'm using is given below:

[Code] .....

Untitled.png‎

View 10 Replies View Related

Excel 2010 :: Macros From Windows To Macs?

May 30, 2013

I developed a tool in Excel 2010 using macros and launched it to a group of dozens of users. Turns out one of them uses a mac and says it is incompatible. I have never used Excel for Mac or tested my tool in it. Next I plan to test it on a mac but how to make this work?

View 4 Replies View Related

Excel 2010 :: Saving And Emailing Macros

Aug 26, 2013

How/ where to save macros. If I save a macro "normally" ("in this workbook") then it only applies to that one file, right? And I can't use it in any new files.

So what do I do if I want a macro I can use in "all" my Excel files?

And can I email a file containing a macro to a colleague, so he can work on the file, using the macro too?

I ask, because I've had trouble with this in the past (tho in MS Word) where I couldn't get the macro to be emailed along with the file...

Also - how can I get an .xls file with a macro to work in newer versions of Excel? And can I use Excel 2010 to save a file with a macro in an .xls format, so it can be opened in older Excel versions too?

View 3 Replies View Related

Excel 2010 :: Legacy Macros Running Slow?

May 26, 2011

I have inherited support for a suite of Excel 2003 spreadsheets with complicated macros which run fine on XP. Having been tasked to test them on Windows 7 with Office 2010, I have not converted them as they are run by several sites globally who may not upgrade to Office 2010 at the same time. Hence they run in compatibility mode which in general is fine.

However, certain macros are veeeery slow and to the user would look like the app has hung. In debug I have found that the macro takes 10 minutes plus whenever it hits any of the following code:

Code:
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With

ActiveWorkBook.PrecisionAsDisplayed = False
It goes slow on each of the three 'lines' so it seems that it is actually doing an auto calc each time!

Is there some configuration I can do to prevent this? Setting auto calc to Manual didn't work and anyway I loose things, like data validation, when I save it in Excel 2010.

View 4 Replies View Related

Excel 2010 :: Macros - How To Update Active Worksheet Only

Oct 7, 2011

I am using excel 2010.

I have a macro-based employee leave system that works by couting the number of days shaded with a certain colour and thus calculating leave days taken, remaining and entitled... I have a single workbook with multiple sheets for different employees.

However, when I update by using ctrl alt f9, it updates all the other worksheets (ignoring their shading) with the values of the active worksheet! So if I update Peter, who has taken 14 days so far, it will update Liam's sheet too, with 14 days, ignoring Liam's actual shaded days...

How can I update each sheet individually, without compromising the other sheets?

Excel is not responding to Shift - F9.

View 3 Replies View Related

Excel 2010 :: Determine And Eliminate Unassigned Macros

Jun 21, 2012

I'm using excel 2010 and have inherited an old workbook that has seen many version updates over the years. The "view macros" list displays approx 25 macros and I know that not all are currently being used or necessary.

The main tab contains macro control buttons. Any macro not assigned to one of these controls is not necessary (it's probably old and was just never removed).

How can I determine which macros are "unassigned" to a control or otherwise invalid?

View 1 Replies View Related

Excel 2010 :: Current Macros Not Running When Recording A New Macro?

Apr 6, 2013

I have a workbook with numerous macros in it and they are assigned to buttons in the different worksheets. I am trying to record a new macro and when I start recording and click on one of the other macros nothing happens. This wasn't a problem in excel 2003.

View 2 Replies View Related

Excel 2010 :: How To Assign RELATIVE Macros To Custom Ribbon

Aug 19, 2014

I currently have an excel workbook (2010) in which I created a custom ribbon and assigned several different macros to the buttons.

Long story short, I will be saving several variations of this workbook every so often when I get new data.

The problem is that if I change the name of the file (Save as or Rename), the custom ribbon buttons no longer work. When I assigned the macros to the ribbon buttons, the macros were absolutely assigned.

Is it possible to assign relative macros to custom ribbons?

From research I have done, it appears that custom ribbons cannot be created using VBA. Is this still true?

View 6 Replies View Related

Excel 2010 :: Macros No Longer Work When Workbook Shared

Aug 22, 2012

Using Excel 2010.

I've created a spreadsheet at work that has two summary tabs which contain hyperlinks to around 30 separate sheet tabs.

On each sheet tab there is a list of unique values in column A (and other information relating to each value in columns B to D which are repeated for more than one unique value). In column E, users enter a test script name against each unique value they wish to 'reserve', and the macro picks out the unique test script names and via the COUNTIF formula counts the frequency of each test script name for each of the different values in column B.

My problem is that the macro seems to work fine if the workbook is not shared, but errors if the workbook is saved as shared. The error is 'Run time error 1004 - Unable to select the MergeCells property of the Range class'.

Here is the macro code:

Sub Get_Policies_Per_Script(updCol As Long, ShtName As String)
Dim rowctr As Long
Dim tgtrow As Long

Const ppsformula As String = "=COUNTIFS($A$3:$A$65000,I$24,$E$3:$E$65000,$G"

If updCol = 5 Then 'test name column has been modified

[Code] ..........

View 9 Replies View Related

Excel 2010 :: Macros Taking Inordinate Amount Of Time To Run?

Mar 13, 2013

I have a 5K Excel 2010 workbook with VBA code that until yesterday, took about 30 sec. to run.

Today, after installation of WIndows7 Home Edition automatic updates, the running time has increased to about 4 min.

View 6 Replies View Related

Excel 2010 :: Lock Out Trust Center Settings For Disabling All Macros?

Mar 12, 2014

There are some excel documents in a hidden folder that contain sensitive information. Shortcuts to these documents will be provided to users to open them and add data. These documents contain all kinds of macros as well. Once macro disables the 'Save As' feature so that the workbook can not be saved outside of the hidden folder, preventing to some degree a user from saving as a different name and emailing the document with the sensitive data.

This all works fine with Macros enabled. As soon as macros are disabled the 'Save As' prevention is bypassed and the workbook can be saved anywhere.

Is there a way for an administrator to lock out the Trust Center options for disabling all macros?

View 9 Replies View Related

Next Order Number Tool In Excel?

Aug 16, 2013

I have an upholstery business and I have created a workbook containing multiple sheets (proposal, invoice, sales order log, etc.. ) Following, I have saved it in Template format, which I open and save by order number somewhere else. The issue is, I don't know how to track what the last order number I used was....

Is there anything I can work using excel that will allow me to make that easier without having to go open a window and looking at the last order number after arranging the workbooks by name inside a folder?

View 4 Replies View Related

Create A Search Tool Within Excel Sheet?

Apr 16, 2012

I've created a spreadsheet containing 200+ entries for my companies suppliers. These include their name/code, contact emails and contact number. This list is far more easily accessible as it saves the user having to bring up the suppliers details within our own bespoke software. However what seemed like a nifty spreadsheet has quickly turned into a giant mush of details with no way to quickly find the one you want without scrolling down to the one you want.create a function/tool that can allow me to type the contact name in cell "X" and have Excel take me to the suppliers line in the table?

View 14 Replies View Related

General Excel Search Tool For All The Functions?

Jun 30, 2013

Is there any excel-addin which offers function in which you could search any excel function (not just formula) so that you could access any function in a seconds, just like google desktop search for windows.

Right now you could use quick access for most common functions you use and shortcuts for functions in different group. But if there is universal search for all the functions, it is going to be faster for any access!

View 2 Replies View Related

Excel Camera Tool - Print Preview Different From Display On Screen

Nov 27, 2012

I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)

Problem Example.png

.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.

Problem Example_Print Preview.png

View 8 Replies View Related

Excel 2011 :: Change Default Formats Of Number Selections In Tool Bar?

Jul 28, 2012

In the toolbar there's a section titled "Number" which allows you to change cell formats with selections named General, Number, Accounting, Date, Time, etc. I want to permanently change some of their default formats.

For instance, currently when I select Number the default is -4000.00. I want to PERMANENTLY change its default to (4,000.00). How do I do this?

View 3 Replies View Related

How To Clear Contents Of Clipboard Before Tool Takes Screen Print In Excel VBA

Apr 20, 2014

I've have a tool/code that takes the screen prints of the active window (when I press F9) and pastes it in a word document.

But whenever I do copy some text or any other image and when I press F9 to take the screen print of the active window. I get the text pasted into the word, this is because the clipboard content has text first and then the screen print of the active window.

Instead When I press F9, I wanted the below to happen

1. Content from the Clipboard should be cleared

2. Take the screen print

3. Paste it in the word document.

Note: My tool/code already does 2 and 3. Looking for 1 alone, ,

View 4 Replies View Related

Excel 2010 :: Getting Outlook Warning (2010) While Sending Email Through Macro

Mar 25, 2014

I am trying to send bulk emails from my excel 2010 - however I am getting a POP UP. find the screen shot in the enclosed word document So every time a new mail is sent from excel we need to press the button allow Is there a way where I can turn off this warning.

View 6 Replies View Related

How To Make Navigation GUI

Jan 23, 2014

I am created Financial Worksheets. . . ex. Balance Sheet, Income Statement, Cash Flows, Notes, Forecasted Sales Etc. and I want to make a GUI in-order to navigate easily. I already included Hyper Links to it for some detailed annexes.

View 4 Replies View Related

Internet Navigation

Jun 16, 2006

I am trying to edit the Copy menus so that they only paste values. I have the following code in the workbook object:

Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window)
Application. CommandBars("Edit").Controls.Item("Paste").OnAction = "New_paste"
Application.CommandBars(" Cell").Controls.Item("Paste").OnAction = "New_paste"
End Sub

Private Sub Workbook_WindowDeactivate(ByVal Wn As Excel.Window)
Application.CommandBars(1).Reset
End Sub

and this code in a module:.........

The module code is however bringing up an error message 'User-defined not defined' and I am not sure why.

View 2 Replies View Related

Form: Textbox Navigation

Jul 4, 2009

I have a form set up with excel (2003) using vba. I'm doing a check to see if textbox1 is empty, if it is, a msgbox pops up with a warning that "textbox1 needs to be filled out". I click OK and the cursor goes to textbox2. I want the cursor to return to texbox1 without user intervention but can't figure out how. I'm using "Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)".
I know it can be done because I did it with vba Access, but I can't seem to find it using vba Excel.

View 8 Replies View Related

Floating Navigation Window

Sep 9, 2009

I want to create a floating window in excel that can contain a series of macro buttons (12 total)

I'd like to see if this window can be opened with a hyperlink or a single macro button on a spread sheet.

View 11 Replies View Related

Next And Previous Navigation Buttons?

Apr 4, 2012

I would like to have a "PREVIOUS" navigation button in a workbook that goes back to the previously activated worksheet, which may or may not be physically the previous worksheet in the workbook. In other words, if I go from Sheet #1, to Sheet #3, to Sheet #5, I'd like to return to Sheet #3 from Sheet #5 (rather then navigating back to Sheet #4).

"Open VB editor and double click 'Thisworkbook' and paste this code in on the right:

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
lastsheet = Sh.Name
End Sub

Then right click 'ThisWorkbook' and insert module and paste this code in

Public lastsheet As String
Sub Select_Last()
Sheets(lastsheet).Select
End Sub

Whenever a user changes sheets, the name of the last sheet is now held in the variable 'Lastsheet' so if you assign a shortcut or button to the code then the last used sheet will be selected."

My problem is that when I want to assign the macro, I can't find macro name that looks anything like the above in the drop down list of Macro Names. how to assign the macro to a button?

View 5 Replies View Related

Navigation Via Combo Boxes

Aug 23, 2005

I am trying to use the combo box feature to navigate between sheets. In other words, I have a dropdown menu at the top of each sheet ("Main Menu," "Goals," etc.) and am trying to work out a macro that directs the user to whichever sheet is selected. Is this possible?

View 9 Replies View Related

Drop Down Navigation Query

Jul 29, 2008

What i want to do is create a drop down list in excel on a single sheet to navigate to a certain row of the worksheet.

I thought i coudl use data validation then use some code in a worksheet change event to skip to that section like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$1" Then
Select Case Target.Value
Case "Test1"
Sheets("Sheet1").Range("A5").Select
Case "Test2"
Sheets("Sheet2").Range("A9").Select
End Select
End If
End Sub

Problem is it wasnt exactly what i was looking for as i cant use an array in data validation so what i thought was a good idea was a bad one.

what i would like is a drop down list that when i select a heading within it, it naviagtes me to that row where my heading is but also makes that row the row scroll up so it is at the top of the page....Hope this makes sense.

my row numbers are 4, 13, 19, 28, 37, 43, 52 62, 65 and 75.

View 9 Replies View Related







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