Over 1 million tech questions and answers.

Solved: Excel toolbar button for the Windows Calculator

Q: Solved: Excel toolbar button for the Windows Calculator

I've been trying to set up a toolbar button in Excel that when clicked will bring up the Windows Calculator, but I just can't seem to find the way to do it. I know it can be done because I used to have it on my previous installation of Excel (Office Basic 2003 and my current installation is the same version).

Now I know I can just click on the Start Menu while I'm in Excel and then just go to Accessories and Calculator, but this is just a personal preference to have a toolbar button that will do the same thing.

I thought there was a Command Option that would allow me to just type in "calc.exe", but there's not. I tried a hyperlink to "Windows/System 32/calc.exe" and that works for the button (Custom button), but it gives a bunch of warnings before the Windows Calculator comes up. And as I recall, I never got those warnings before (one warns about hyperlinks and the other is similar).

And I looked on all the toolbar choices and I couldn't find any Windows Calculator button. There IS an Excel calculator button(s) to recalculate spreadsheets, but that's NOT what I want - I want the Windows Calculator.

I tried recording a macro and assigning it to the button, but the minute you go out of Excel the macro recorder doesn't record.

I also tried VBA, but I couldn't find any simple code to execute the calc.exe program. I thought maybe there would be a simple "run" statement, but I don't think there is. Actually, I'm not all that familiar with VBA code, so maybe there IS a way to do it with VBA.

But I certainly didn't use VBA the last time I did it. It was something simple (and, YES, I know that going through the Start Menu would probably be just as simple, but now it's become one of those "challenges").

And I've Googled and gone to the MS Office site, and still not found anything of help.

Anyway, this isn't really a "stop the presses" inquiry here. Just wondering how I did it before.

Any hints???

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel toolbar button for the Windows Calculator

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel toolbar button for the Windows Calculator

Actually... I'm running Office 2003 Pro and it has the Windows Calculator as a button called "custom". Under Toolbars> Customize> Commands Tab, clicked on Tools in the left window and scrolled about 2/3 of the way down in the right window. I've got two "Custom" buttons listed after "Camera" and before "Select Names"; one with a deck of cards icon and the other with a calulator icon. Drug it up to my tool bar, saved the settings, and the Windows calculator opens from it. Solitare opens with the deck of cards icon

I didn't even know they were there.... cool.

Read other 2 answers
RELEVANCY SCORE 64.8

Good Day,

I'm creating a vacation calculator for work. I need it to multiply the months here by hrs worked times (whatever the month value set by company). im stuck in the last part. im using vlookup but it comesback that the cell formula is volatile. i've have been at this for 2 days. help please. im using office 2010 on a window 7 computer.

thanks
 

A:Solved: Vacation Calculator excel sheet.

Read other 9 answers
RELEVANCY SCORE 62.8

This neat calculator on bottom bar suddenly disabled. How to enable it?
I'm sure easy fix, but tried the View menu, nothing there.
 

A:Solved: Restore Automatic Calculator at bottom of Excel 2010 spreasheet

what version of excel
on 2007 up - right click on the bottom bar and you should see a choice including sum, etc
or
tools>view>status bar
 

Read other 3 answers
RELEVANCY SCORE 59.2

I just tried the "Zwinky" site and now I want out. I cancelled my account, but IE8 still has the "Zwinky" button on a toolbar . How can I permanently remove it?
 

A:Solved: IE8 toolbar button removal

Read other 6 answers
RELEVANCY SCORE 59.2

Can anyone tell me how to adjust the size of the buttons on my toolbar. what i want is just a picture, not the lettering. I've attached a example to help you better understand
 

A:Solved: Toolbar Button Size

Read other 6 answers
RELEVANCY SCORE 58.8

I have a custom tool bar that I want to disable a specific button depending on where I am in the program. One of the buttons on the toolbar is named "Go To...". This button when chosen has about 12 other buttons that when selected take the user to various sections of the program. I want to be able to disable a specific button within the Go To... button. Lets say one of the buttons in the Go To Button is called "Projects". When I am in the projects section of the program, I would like the Projects button to be disabled. Obviously, there's no need to select it because the user is already there.

Thank you...
 

A:Solved: Disabling a Specific Toolbar Button

Read other 16 answers
RELEVANCY SCORE 58.8

The toolbar macro I created works fine as long as I run it using Alt F8, but I can't keep the Button on the toolbar ( That's what the button's for ,so I don't need to use the Alt F8 method). It disappears once I close Outlook, save the VB project and then reopen Outlook. This only happens on this PC. I have the identical system on my LapTop and the button is aways there as it is supposed to be when Outlook is opened, but not on this desktop PC.
Anyone have any ideas? This one has me stumped. I have already removed and reinstalled Outlook and it did not fix the problem.
 

A:Solved: Outlook 2003 Toolbar Button

Read other 14 answers
RELEVANCY SCORE 58

I?ve added a middle-mouse functionality to a toolbar button. How do I make the button look active (?pushed? - as it does on a left-mouse click) on a middle-mouse click?
Thanks

A:[SOLVED] A toolbar button and a middle-mouse click

Have you tried setting it up on the control panel/mouse ?

Read other 2 answers
RELEVANCY SCORE 58

Hello,

When working on a document, I added a web button to the toolbar but when opening a new document, it is not there. What do I need to do to keep this button on all documents/the normal.dot template?

Thanks
 

A:Solved: Word 2002, button on toolbar disappears

Open normal.dot, add it and save, making sure you are saving back to normal.dot
 

Read other 2 answers
RELEVANCY SCORE 58

We know that in Windows XP, through the "Folders" button on Toolbar(in Explorer) may turn the “Folders Tree” On or Off;

In Windows7, you can click Organize(on Explorer Toolbar), point to Layout, and then click Navigation pane to turn the Navigation Pane On or Off.

However, Is there a simpler way to turn the Navigation Pane On or Off in Windows7?

For example,there is a "Show the navigation Pane." button on Windows7 Toobar
(looks like the "Show the preview pane." button on Windows7 Toobar or the "Folders" button on Windows XP Toobar)
click the "navigation Pane button" to be possible directly to turn the Navigation Pane On or Off.
(instead of "click Organize, point to Layout, and then click Navigation pane to display/hide it.")

okey,my question is:
How to Show(or Create) a button(“Show the navigation Pane.”) on Toolbar in Windows 7?

see screenshots below:
Windows7-Navigation-pane-Button-Hide.jpg
Windows7-Navigation-pane-Button-Show.jpg
Windows-XP-Folders-Tree-Hide.jpg
Windows-XP-Folders-Tree-Show.jpg

A:How to Create a button on Toolbar in Windows 7?

Yes i really want the answer to this question as well. why arent more people asking about it? it seems so obvious! and why did microsoft not provide support for it! i mean duh!

there are several sites which talk about how to do this. but as you can see its bulky when you have to have the full word "navigation pane" spelled out.

please someone figure this out and post back. thanks

Read other 4 answers
RELEVANCY SCORE 57.2

I found it was convenient after renaming files and folders. In Vista I have to click View > Refresh, but there is no hotkey or button that I can find. Anyone know if it's possible?

A:A Refresh button in the Windows Explorer toolbar?

I've always doing it "View > Refresh", but I could imagine the convenience of that button.. possibly right click- refresh?

Read other 4 answers
RELEVANCY SCORE 57.2

I know a lot of others are plagued by the Start button issue. I am as well. But, also my Calendar and Calculator stopped working as well.

I have tried SEVERAL solutions. Re-installing all apps via Powershell, re-installing Windows 10 and creating new accounts. Nothing I do seems to help.

Getting tired of this, especially the Start button failing. thanks.

A:Multiple issues: start button/calculator/calendar not working

Hi, tends to be more prevalent where people have done upgrades rather than clean installs, but you're reporting clean installs. Never seen a clear explanation of why it happens- I've run Win 10 on 2 PCs with many progs installed and not had significant problems for months.

Note the Powershell commands used to repair apps e.g. break many post build 1511 (10586) unless there's been a recent change.

Bottom line- to fix your PC
Repair Install Windows 10 with an In-place Upgrade - Windows 10 Forums

This keeps all settings and programs.

And support it with 3rd party disk imaging, so you can considerably more quickly than the above get your PC back to a working state.

Also enable System Restore, set up a scheduled task to create a restore point e.g. daily. (The tutorial section can help here on creating the restore point)

To try to diagnose its occurrence, keep a simple log of changes to your PC, and try to correlate that with this happening.

See what happens if you boot to Safe Mode when the symptoms occur. If the start menu etc works then, something is conflicting with Windows. If not, sthg's corrupted. Probably.

Read other 0 answers
RELEVANCY SCORE 56.8

Hi Brink,
First I want to thank you for your great solutions.
I need your help to delete some of the items on the top of windows 7 explorer
I need to get rid of some of the those items, infact most, I hardly use them
Can you help me delete at least "Burn"?

A:Delete toolbar button items at top of Windows Explorer?

Hello Fakts, and welcome to Seven Forums.

As far as I know, there is no known way to remove these toolbar buttons in Windows Explorer.

Read other 6 answers
RELEVANCY SCORE 56.4

When I start my computer (a four-year-old Dell which runs Windows XP Professional), it loads without any problem, but when Windows starts, it won't display my desktop icons or the Windows bar that's normally at the bottom of the screen (including quick launch, the start button, the clock, etc.). The only thing that is visible on the screen is the My Documents folder (not Desktop or My Computer or anything else...always My Documents). Of course, from there I can navigate around and get things done, but it's obviously not ideal.

I originally posted the problem on the BC Malware forum (http://www.bleepingcomputer.com/forums/topic365343.html), but none of the scans and logs turned up any malware, so the person who was helping me suggested I take the problem to this board.

I think that's everything...please let me know if there's anything else I can add to make the problem clearer. Thanks for your help!

A:Windows Toolbar and Start Button Won't Load on Startup (Windows XP)

Do you get the same problem if you start in safe mode?

Read other 3 answers
RELEVANCY SCORE 56

Hi Guys.

I'm looking to create an excel spreadsheet that records absent hours against contracted hours on a weekly basis, and generate a monthly, quarterly and yearly report with graph.

now before I throw myself in the deep, do any of you guys know of anything similar already out there, so I don't have to reinvent the wheel!

Thanks in advance!

mad-martin
 

A:excel absence calculator

Hi, I'me sure there are quite a few around, have you Googled?

I found this link and there are many more
http://www.excelfunctions.net/excel-calendar-2015.html

I'm sure there is one that will do what you require, maybe some small changes but...
 

Read other 1 answers
RELEVANCY SCORE 55.2

The company I work for utilizes military time for all production tracking and I'm thinking of helping the specialists out by creating a simple excel program to figure out the total time, in hours, that we should charge our customers.

The formula should be pretty simple but I'm finding it difficult to hash out in Excel. I need the user to be prompted to provide a Start Time, i.e. 1500 (3:00pm) and then provide and End Time, i.e. 2250 (10:50pm). The output should be in the form of total hours, rounded-up to the nearest tenth. So, in this case 7.9 hours.

Here is the conversion chart that the specialist utilize on the production lines.
Minutes - Hours
1-6 - .1
7-12 - .2
13-18 - .3
19-24 - .4
25-30 - .5
31-36 - .6
37-42 - .7
43-48 - .8
49-54 - .9
55-60 - 1.0

I am currently unable to upload anything from the computer I am using due to security measure and policies. Any help with this would be greatly appreciated.
 

A:Military Time Calculator in Excel

try

=INT(A2)*24+HOUR(A2)+ROUNDUP(MINUTE(A2)/60,1)

see attached

row 2 - for the calculation to subtract 12hr time to milt time
 

Read other 3 answers
RELEVANCY SCORE 54.8

I am using WLM 2011 installed on Win 7. Please can someone explain if its possible to set the quick access toolbar at the top to just send and receive frome e mail accounts only without syncronising feeds and newsgroups? I know I can do this going to the Home tab & Clicking the little arrow under send and receive and selecting this option from the drop down list but it would be much easier if this could be done from the quick access tookbar. I found using WLM on XP had a more user friendly interface.

Your thoughts would be appreciated.

Kind Regards

Chris

A:Windows Live Mail Quick Access Toolbar Send Receive Button

Ah, I just found a reply to my own post here in case anyone finds it useful.

Windows Live Mail 2011: How to Customize the Quick Access Toolbar | Microsoft Windows 7 | Tech-Recipes

Using the option under the Home tab & Clicking the little arrow under send and receive and selecting the option "send and receive all e mail accounts then /right click/ add to quick access toolbar. Now I have a new button that does just what I want. I can always right click the unwanted button from the quick access toolbar and select remove if I wish.

Kind Regards

Chris

Read other 1 answers
RELEVANCY SCORE 54.8

I have an add-in that installed its own menu item on the ribbon bar. From the ribbon there are a bunch of functions that can be inserted as well as toolbars. The functions work fine but I can't see any of the toolbars.
 

A:Solved: Can't see 3rd party toolbar in Excel 2007

Hi sync

Can you give us the name of the add-in and post a link to the third party program you are using?
 

Read other 3 answers
RELEVANCY SCORE 54.8

Posted this on another forum on this site and didn't get a solution.., come on Bomb#21 etc - don't let me down...

I have attached a screen shot which shows 3 programs running on the task bar at the foot of the screen.

Immediately prior to taking the screen shot, I had clicked on the middle program button which read "5 Microsoft Outlook", as (for the slow of mind) I had my Outlook inbox open and 4 mail messages/attachments open. The 5 Outlook 'files' were then displayed at the foot of the screen and I could click on any one to switch to it.

To the right of the Outlook button I have an Excel button which doesn't tell me how many Excel files I have open (there were actually 3 at that point) and (here's the problem !) doesn't allow me to click on the task bar button and click again on the file I want to switch to.

It's not a major problem, but it is a major source of annoyance.

At the risk of sounding like an ungrateful git, could someone tell me how to sort this once and for all, rather than "try this" or "try that".

A few weeks ago it was definitely do-able and I don't know what I have done to change things. I have tried changing the toolbar properties to group/not group similar files, but can't seem to get the result I want.

OK - rant over. I'm using XP Pro (2002 SP2) and the Excel version is 2000 (9.0).
 

A:Solved: Excel/Task toolbar problem...

Read other 6 answers
RELEVANCY SCORE 54.4

I recently downloaded a user mod for a Tom Clancy game from a reputable web site and checked for viruses, it was clean. After install every time explorer opens the calculator pops up aswell I have erased mod, restarted and repair installed windows xp. is there a setting that can cause this to happen or do I have to backup and format/install windows?
 

A:Solved: Windows XP calculator keeps popping up.

Read other 10 answers
RELEVANCY SCORE 54.4

can i use code in a macro button to insert and change a value in a cell, what i want to do is set up a macro button so that when it is clicked the value in cell a1 = 1, when it is clicked again the value changes to 2 and so on upto 5, when it gets to 5 a value of 1 is entered in cell b1 and the value in cell a1 reverts back to 0, or is there a different and easier way to gets this to happen.

many thanks
scouse13
 

A:Solved: excel macro button

Will you follow the same logic and then move to cell C1 after 5 clicks have been made on cell B1? What exaclty are you tracking?

Rollin
 

Read other 2 answers
RELEVANCY SCORE 54.4

I have an excel spread sheet where I have certain cell that I clear each time I use this as a template. Can someone tell me how to use a command button to do this. The cells are E3:E10, E5:E20, G3:G20 & F24. I just want to clear the the number in the cell... not the formatting.

thanx
 

A:Solved: excel command button

this should do it...
Code:

Sub Macro1()
Range("E3:E10").ClearContents
Range("E5:E20").ClearContents
Range("G3:G20").ClearContents
Range("F24").ClearContents
End Sub


but I'm confused as E3:E10 and E5:E20 overlap, in which case you can replace the first two lines with range("E3:E20").clearcontents
 

Read other 2 answers
RELEVANCY SCORE 54.4

hi
can anyone please show me how to setup a command button on a excel worksheet.
what i want to be able to do is click on the button on say sheet 1 and for it to open sheet 2 and go to a particular cell reference.
unfortunately as i am just learning how to do this i do need a step by step guide
thanks in anticipation
 

A:Solved: command button excel

see if these help
http://www.ehow.com/way_5427348_tutorial-excel-command-button.html
or
http://www.taltech.com/support/sw_tricks/exmacros.htm
 

Read other 2 answers
RELEVANCY SCORE 54.4

I need some assistance creating a macro to automate a process by clicking on a button. I would like to have multiple functions performed when a single button is clicked. They are:

1. Save the active file
2. Open a new mail message (and attach the active file if possible)
3. Fill in the To: with "[email protected]"
4. Fill in the CC: with "[email protected]"
5. Fill in the subject with "Performance Tracker"

Is this possible? I have no idea where to start other than I know it will require VBA. Can someone help?
 

A:Solved: Excel Macro for Button

Read other 8 answers
RELEVANCY SCORE 54.4

Hi,

I'm trying to add a search macro to the search button in the 'search' sheet in the attached. I'd like it to search all the other sheets (minus the 'index' sheet) and then display the results within that sheet.

Thought the easiest way to show this would be through putting in entries in all of the sheets and showing how I would like them displayed (example results in the red text). The corresponding search to these results would be 'bread'.

Would be grateful for any suggestions on how this could be done.

Mnay thanks in advance.
 

A:Solved: Search button excel

Read other 10 answers
RELEVANCY SCORE 54

The worksheet button disappears after macros runs. I'm the IT repair guy, not an Excel expert, so I’ll describe this as best I can. I understand this file basically does a checksum on a bunch of files. At the end, it is supposed to display some VBA script macro buttons, but all I get are some squares with Xs in them indicating an image is missing. The same file works on other computers, just not this one. I've uninstalled/re-installed Office but no help. I took a working file from another computer but it doesn't work on this one.

I have to assume there nothing wrong with the file or Excel, but something set wrong on this computer.
 

A:Solved: Excel macro button disappears

I am just guessing, but it sounds like you may have a custom button set for the macro and it either doesn't exist on that PC or does but in a different location.
Check this out
http://www.vertex42.com/ExcelTips/excel-toolbar-buttons.html
and this
http://articles.techrepublic.com.com/5100-10878_11-1060039.html
You may just want to make your own button and give it the same name as the one that the macro is looking for.
 

Read other 2 answers
RELEVANCY SCORE 54

Good morning all!
I have a Excel 2003 workbook which contains one control button on a worksheet (not on a form, boy I wish it was).

I need to have a macro run when the user mouses over the control button...not click it. Clicking the button will run a different macro.

Mousing over the button does cause the cursor to change from a "cross" to a "hand" so we know that Excel recognizes the mouse over.

If this can't be done, is there an alternative...perhaps hide a text box under the button which can detect a mouse over, or any other kind of control or cell that can detect mouse over.

Sample workbook attached (I think).

Any help is greatly appreciated,
Tom
 

A:Solved: Excel 2003 button mouse over help

Solved and if interested, here's what I did. First off, I was using a button from the Forms Tool bar. I switched to an ActiveX (actually 2) CommandButtons from the Control Toolbar. I put one directly on top of the other with the top one about 2 pixels smaller all of the way around. These Commandbuttons have the MouseMove function available.

Now for the programming: All programming is done in the Sheet code area. Both buttons have a MouseMove macro. The inner (main) button updates the time and sets a boolean variable true to prevent recursive triggering. The larger button clears that variable. This was the only way I could figure out how to recognize entering the buttons and exiting them.
The inner button also has a 'click' macro to call the proper subroutine. Obviously the purpose of this button is not to change the time...that just seemed to make for a good and simple example.

The working workbook is attached here.

Thanks to all of the lookers for your time,
Tom
 

Read other 1 answers
RELEVANCY SCORE 54

Excel 2007 - Previous threads suggested creating a Macro to clear the data in the worksheet, which defines specific cells to be deleted.

If you need to reset the entire sheet or even one cell, then follow these simple steps using VB code.

Step 1: Select the entire worksheet, right click on any cell and select "Format Cells", select the "Protection" tab and click the check box "Locked". This will lock all cells. Click OK.

Step 2: Right click all cells that you want the data cleared and follow the same procedures in Step 1.

Step 3: Go to top Tool bar and select the "Developer" tab and click. In the "Controls" box select "Insert", in the ActiveX Control and select "Button" and place on your worksheet.

Step 4: In Top Tool bar click Design Mode, click on your new "Button" to select.

Step 5: In top Tool bar click "View Code" or right click your Button, in this VB window paste this "Code" I have in blue text:

Private Sub CommandButton1_Click()

ActiveSheet.Protect
On Error Resume Next
ActiveSheet.UsedRange = ""
On Error GoTo 0
ActiveSheet.Unprotect

End Sub

Step 6: Click on Design Mode, type text in one of the cells you have "Unlocked" and click your new Reset Button.

You can reuse this Rest Button on any worksheet by copying and pasting it. Just remember to define which cells are to be "unlocked".

 

A:Solved: Excel Form Reset Button

I have removed your advertising link please do not post these types of links - next time will be considered SPAM
 

Read other 3 answers
RELEVANCY SCORE 54

I have placed a command button on one of my worksheets. The command button is used to place an image on the worksheet.

I would like to set the command button's property Enabled to false once it has inserted the image on the worksheet. However, I am unable to figure out how to do that through code.

Also, is there a way through code to determine if teh image was inserted?
 

A:Solved: Excel 2007 -> Command Button

Read other 13 answers
RELEVANCY SCORE 54

Hello Everyone,

I'm new to this forum. I'm trying to add search button in my excel sheet to find the data from database.
Eg. There are 10 stores and am looking for a particular product I just need to enter the Unique Code and click on Search and it will provide the Store Name which has it along with Quantity. If more than one store has the same product then all stores names should appear with quantity.

I have attached sample file. Thanks in advance!
 

A:Solved: Add Search Button In Excel 2007

Hi, welcome to the forum.
Have you tried recording a macro? You can then edit it if needs more functionality and the either add it to the QAT bar or assign the macro to button you can place on that particular sheet.

BTW you could also use AutoFilter
 

Read other 2 answers
RELEVANCY SCORE 54

Is it possible to set the VISIBLE property of a command button to FALSE when the command button is clicked?

I want to set the VISIBLE property of the active command button to FALSE.
 

A:Solved: Excel Macro -> Command Button

Read other 13 answers
RELEVANCY SCORE 53.2

Thereís a command button on my spreadsheet that canít be deleted at least through ordinary means. This is what Iíve tried:
1. The straight forward way by right clicking the button, then selecting cut. Some processing takes place, but the button remains.
2. Again the straight forward way by right clicking the button then hitting the delete on the keyboard. The same thing happens.
3. Just for fun, I moved it from is initial location to another location on the same spreadsheet. Now there are two identical buttons that canít be delete.
4. I donít know why, but I did it again. The new button that appears can be deleted, but not the other two.
5. Assigned a different macro to each of the two buttons and each worked properly, but still the buttons canít be deleted.
6. Copied the original to another sheet. It was easily deleted, but still canít delete the first two buttons.
7. My final try was to use the Visual Basic Editor to see if thereís a macros embedded in the sheet itself. No, nothing there.

Canít think of what else to try, except to ask for help.
 

A:Solved: Excel 2003 Command Button, Can't Delete

Read other 12 answers
RELEVANCY SCORE 53.2

I have the following code behind my Excel workbook...
Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Close is Disabled"
' Following line will prevent close from working
Cancel = True
End Sub
I would like to be able to use a command button to close the Excel workbook.
 

A:Solved: Excel 2003 Close Command Button

Read other 12 answers
RELEVANCY SCORE 53.2

I have placed a command button on my worksheet. However, my worksheet could contain hidden rows.

Is there a way to have the command button to only print the visible rows, and not the hidden rows?

Here is the code I have behind the command button now....
Code:


Dim r1 As Range

With ActiveSheet
PageSetup.PrintArea = ""
Set r1 = Range("A1:O250")
r1.Select
Selection.PrintOut

Range("A3").Select

End With

 

A:Solved: Excel 2003 Print Command Button

Read other 16 answers
RELEVANCY SCORE 52.8

Good afternoon all,

I use Excel 2003 on WinXP Home SP3. I have an Excel query that pulls from an ODBC connection.

The problem is that the Edit Query button is greyed out. I can manually select Data --> Import External Data --> Edit Query, and I can manually right-click a cell and select Edit Query, but when I add the Edit Query button to the Toolbars, the button becomes greyed out and I cannot click on it.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Intel(R) Core(TM)2 CPU 6320 @ 1.86GHz, x86 Family 6 Model 15 Stepping 6
Processor Count: 2
RAM: 3069 Mb
Graphics Card: NVIDIA GeForce 8300 GS, 512 Mb
Hard Drives: C: Total - 152617 MB, Free - 139098 MB; D: Total - 171702 MB, Free - 159905 MB;
Motherboard: Dell Inc., 0CT017
Antivirus: Microsoft Security Essentials, Updated: Yes, On-Demand Scanner: EnabledClick to expand...
 

A:Solved: Excel 2003 - Edit Query button greyed out

Read other 11 answers
RELEVANCY SCORE 52.8

Hi Everyone

Hope someome can help me.

I currently use the following code to open a word document from within a spread sheet using a command button. The word document is in a seperate folder. I use Excel 2003.
Code:
Private Sub cmdautomateword_Click()

Set wordapp = CreateObject("word.Application")

wordapp.documents.Open "C:\Users\Home\Course Acceptance\Letter.doc"

wordapp.Visible = True

End Sub
I know very little about VBA but I now need to be able to open an existing Workbook within the same folder.

Can anyone help with the code to be able to open the existing Workbook ?

Thanks in advance

Ortz
 

A:Solved: Opening an existing workbook in Excel with a Command Button.

For simple tasks like this all you need to do is use the macro recorder and then view the code that was automatically created.
Code:
Workbooks.Open ("C:\Users\Home\Course Acceptance\Test.xls")

Rollin
 

Read other 2 answers
RELEVANCY SCORE 52.8

Hi guys

Is there a way to unhide the next hidden row (out of all hidden rows in the sheet) based on the location of the button clicked?
Basically what I need is a macro that works with any button (without specifying a concrete name for the button). Based on the row where clicked button is located (there will be cca 15 of them on the sheet), ie row 15, it will unhide next hidden row but leave all hidden rows above hidden.

Hopefully, I didn't confuse you too much.

Thanks a lot!

Michael
 

A:Solved: Excel: Unhide next hidden row based on button position

Read other 10 answers
RELEVANCY SCORE 52.8

Hello,

I was hoping someone could provide me with some detailed instructions on how to create a macro to automatically sort some columns I have and then enable it so that I can place a button on the worksheet which will activate that macro.

Any help would be greatly appreciated!
 

A:Solved: Running A Macro Using A Button In Microsoft Excel 2007

Is anyone able to help me with this?
 

Read other 3 answers
RELEVANCY SCORE 52.8

I have placed a command button within my excel worksheet. I would like to have a inputbox popup when the button is clicked, the user enters the worksheet password, if the password is correct then unprotect, and if the password is incorrect give a messagebox telling the user the password is incorrect.

Any help with this would be appreciated.
 

A:Solved: Excel 2003 Unprotect Worksheet Command Button

Read other 16 answers
RELEVANCY SCORE 52.4

Hi,
I know this is probably an easy question, but I've searched repeatedly on the web and I can't find advice there or in the forums because I'm missing some kind of terminology.

I want to be able to highlight multiple words in Excel and see the home toolbar open every time I open a spreadsheet.
Longer explanation:
I'm using Microsoft Vista 2007 with Excel 2010. I use Excel to make quite a few spread sheets to study for school, and I often have to selectively highlight multiple certain words by hitting ctrl and holding ctrl while highlighting the words. Next I would underline all of the highlighted words. About a month ago it was working fine.
Suddenly out of the blue whenever I try to highlight multiple words by holding ctrl in Excel it won't work. Also, previously when working in excel 2010 the top menu bar would stay on home toolbar with all the option listed, meaning I could keep tinkering with the font uninterrupted. Now after underling just one word at a time the toolbar keeps disappearing with the File tab highlighted green, and I have to keep clicking back to the home tab, then click underline. Have to repeat highlighting each individual word,, clicking home tab, and then underlining. Ugh!
I would love to hear some advice before I tear my hair out in frustration.
 

A:Solved: Excel 2010 unable highlight mutliple words & toolbar problems

Read other 6 answers
RELEVANCY SCORE 52

Whether it's a new spreadsheet, or an existing one, when you click anywhere on the sheet, it acts like your clicking down the left mouse button and dragging. All cells within the movement of the mouse are being selected.

Replaced the mouse, which was wireless, with a PS2 Mouse, and still have the problem.

Running Windows 2K prof SP4

MS Office 98.

Any ideas?
 

A:Solved: Excel - Symptom [left mouse button click hold]

Read other 16 answers
RELEVANCY SCORE 51.6

I have several reports from a database that I have built for my boss to see different views of work progress. She currently copies and pastes to put them in Excel.

I'd like to provide her with a button she can click to Export everything to Excel for her. She is not the most tech-savvy, so showing her how to do it within Access is not a feasible option (she'd just ask me to show her every time she needed to do it).

Thanks in advance!
 

A:Solved: Access 2007: Creating a Button to allow user to export report to Excel

In Form design Mode the Form "Button Wizard" will create the button for you.
The fourth item on the "button sub menu" is Report Operations and on the right hand side the last option is Send Report to File.
You then select the report that you want and then "Output to MS Exel"
 

Read other 2 answers
RELEVANCY SCORE 51.2

hi. how do i add the button "add to windows media player list" to the windows explorer toolbar please? i would like it to work when a folder full of tunes is highlighted as well as when individual tunes are highlighted. it would be quite nice if the "play" button works when a folder is highlighted as well. thanks, Alex

A:add button to toolbar "add to windows media player list"

Welcome to Seven Forums acm0000. I am unaware of a way to add those specific buttons. You can however left click and highlight multiple files, then right click the selections and both add to windows media player list and play will be choices. A Guy

Read other 1 answers
RELEVANCY SCORE 50

Does anyone know how to create your own button to add to the Toolbar in IE, for instance instead of having "Media" I could have a button that started my FTP program. Many thanks
 

A:Button on IE toolbar?

This may get it.

http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/ext/tutorials/button.asp
 

Read other 3 answers
RELEVANCY SCORE 50

When I purchased my Dell Inspiron Laptop, I used IE and I noticed I had a toolbar button (like the mail, print,edit) named Research. I had to reinstall windows after some software problems started to occur. After reinstalling windows, IE was reinstalled and the research button is no longer there. I never downloaded any extra toolbars, so I'm not sure where to get this button from. I would like to get it back. It was like a dictionary/thesarus type of thing.
 

A:IE Toolbar Button

Read other 6 answers
RELEVANCY SCORE 49.6

I'm a noob who needs help.

When I open a folder that contains files, then highlight the file I want, the little button that says email no longer works. It used to automatically open Outlook and have a message with the selected file attached ready for me to enter a recipient. Now when I click that button nothing happens. How can I fix it?

Thanks!

A:Email button in toolbar does nothing

Hello Saxby, and welcome to Vista Forums.

You migh check in Default Programs to make sure that Outlook is set as the default program with all of it's associations set to it.

Hope this helps,
Shawn

Read other 1 answers