Add-in Created; And Added Via Tools, Add-in
Jan 25, 2008
I've created and excel spreadsheet that has code like this in a Module named Print w/ in the workbook:
Sub Print_wsPrint()
Sheets("Print").PrintOut
End Sub
I have saved it as an MS Office Excel add-in.
I added the add-in to my excel environment via Tools, Add ins...and let it copy it to my C:Documents and SettingsjohnApplication DataMicrosoftAddIns directory.
But yet when I create a menu button and assign the Print_wsPrint to a custom menu, it complains and says "The macro Model.xls!Print_wsPrint cannot be found," where Model.xls is the workbook I am in. It's in my add-in, not in the current wb.
View 9 Replies
ADVERTISEMENT
Oct 10, 2008
I'm "missing something" here. I used the EOMONTH function in a recently developed workbook. In order to activate that function, I had to go to the Tools menu, select the Add Ins option and add the Analysis Toolpak to my Excel configuration ... no problem, worked like a charm. Then I sent the workbook to another user. Of course, the EOMONTH function came up with errors when she opened it. I talked her through the Tools/AddIns/Analysis Tookpak configuration change ... but could not get the EOMONTH formula to work.
View 5 Replies
View Related
Jan 21, 2010
Just discovered the drawing tools on my quick access tool bar are disabled. All were enabled and working fine just yesterday. I'm running 07 on xp. I've shut down and rebooted, no change. Need to know how this could have happened but mostly, how to enable.
View 9 Replies
View Related
Jun 27, 2006
I use several different workbooks during the day, and sometimes I would prefer the " move selection after enter direction" option to = "Right" and sometimes "Down". It doesn't seem to be an option that is saved with the workbook.
what could be done to a workbooks code to change this option upon opening the book?
View 2 Replies
View Related
Oct 31, 2006
I placed an add-in (.xla file) with a " function" and a "sub" into C:Microsoft Office XPOffice10Library. When I go to Tools-->Add-Ins the Add-In doesn't show up. When I browse the file it says it already exists and still doesn't show up. The strange thing is that the "function" does work, but the sub (which is a sub worksheet_change) doesn't run. I also tried doing the steps as they are laid out in http://www.ozgrid.com/VBA/excel-add-in-create.htm and ended up with the same problem. The function works when I open up a brand new Excel application and use Book1, so I know the function isn't embedded in the sheet.
View 4 Replies
View Related
Feb 13, 2009
I have installed Excel 2007 but cannot find the tools menu [or tab]? I see tabs like 'Home', 'Insert', 'Formulas', 'Data', etc. but no tools?
View 2 Replies
View Related
Feb 5, 2010
Why when I open some files that have macros and I enable macros on initial opening and then go to tools-macro-macros it's not showing anything there, but when I press Alt F11 then I can see macros?
Is there any way to change this that I can see all macros from tools-macro-macros?
View 9 Replies
View Related
May 2, 2006
When I choose tools -----> options from the menu bar nothing happen I can not changes my options. I am using excel 2000, I must of changes something but I don't not remember what. Can someone help turn back this option
View 9 Replies
View Related
May 1, 2014
VBA code to extract excel report from tools e.g. SAP or other tools.
View 3 Replies
View Related
Sep 2, 2009
Is there code available that will hide the Tools Menu within excel?
View 5 Replies
View Related
Jan 26, 2007
I want to hide and unhide tool / macros menu so that users don't run the macros in the workbooks.
View 9 Replies
View Related
Feb 25, 2008
I am setting up VBA code to create different excel workbooks. One of the differences is in the VBA Tools References that must be enabled to make the whole thing function.
How do I write VBA code to turn on and off specific tool references ie. if i had a reference called OrbitCOM Library how can I turn it on and off using VBA code.
View 9 Replies
View Related
Nov 21, 2006
On one of my computers, Excel is freezing up just about any time I select something from the Tools or Format Menus (same goes if I use keyboard shortcuts to call any of those things). I have to kill it with the task manager. It is not a specific workbook, I've tried several, including new blank workbooks.
It's not all menus, as File options seem to work. I also am able to Autosize columns by double clicking, but basically any other formatting things (i.e. CTRL + 1) do not work. I also tried to show the Cell Format dialog via VBA, (note: I am able to get to VBA editor, etc...), and it locked it up then too.
Finally, I tried "Detect & Repair" from the Office disk, but that didn't do anything. Next, if necessary, I'll do a full re-install unless anybody else has heard of this and knows what the problem is.
View 2 Replies
View Related
Jun 27, 2013
We have created a macro that basically looks for rows that contain an "H" and hides the row if it does.
Users can add new rows throughtout the year to this spreadsheet. and based on certain criteria, an H or U will be placed in a hidden column which the macro looks at and hides any row it finds an H.
The user has to click on the button that has the macro assigned to it once they have finished working on the spreadsheet.
The problem we're finding is that for users who insert/delete rows, once they click the button it takes up to 15 seconds to run through macro (which is ok). However, users who haven't added or deleted any rows and who click the button, they have to wait upto 5 minutes (which isn't ok) for the macro ro run.
We can't figure out why the macro takes longer to run when no changes have been made?
View 8 Replies
View Related
Dec 9, 2008
I have a spreadsheet with check boxes and a combo box that are set to display in print preview as well as print. I have set up a Print Preview button on this spreadsheet, as well. When you click the Print Preview button and then click close on the preview window and return to the spreadsheet, the control toolbox tools appear out of place and are greatly magnified. Scrolling the screen down and then back makes them appear correctly once again.
I have seen this on this spreadsheet on three different computers. Does anyone have a clue what is going on?
Note, clicking the print preview button on the standard toolbar does not provide the same artifact. It works correctly.
Or for the cheap fix, what is the VB script to move the cursor to a different cell and then return back?
View 9 Replies
View Related
Mar 10, 2009
I can't find anywhere where there may be some VB code to allow text within a cell in Excel to be circled. I don't want drawing objects, because many times I need to modify 30-40 sheets at one time and Excel doesn't allow you to alter drawing objects when you have multiple sheets selected. Therefore, I just want to be able to apply a circle around some text in a cell the same way you would underline it, for example. I figured my only hope is VBScript?
View 9 Replies
View Related
May 17, 2006
how can I change via VBA the chart options in tools--> options-->charts
View 4 Replies
View Related
Oct 4, 2006
i am preparing my self to enter the microsoft Excel 2003 Exam.....
one of the mentioned points in the preparation list is: (Perform data analysis using automated tools) how to use the automated tools? and if possiable to get a file that i can apply these tools on it
View 2 Replies
View Related
Apr 3, 2007
how to change the name of a Command Button that I have called "Command Button" on the Tools menu.
Also if I have this button created in my Personal workbook and I send the file to another user what should I do? Will that user be able to see this button ok?
View 4 Replies
View Related
Oct 27, 2006
I have a table with rows that keep growing. But I have place formula in the whole of column F, i.e. F2:F66565. When I import information from MS Access into column A to E, the formula in F does not work, until I copy from F2 to the end manually. I have tried using Tools, Options, Calculation, Automatic. That doesn't work, I have also tried F9, that doesn't work and I have also tried checking Precision as Displayed under the calculation tax in Tools-Options, that doesn't work either.
View 3 Replies
View Related
Feb 4, 2009
I have the following data retrieved via import data tools ...
View 9 Replies
View Related
Jan 21, 2008
I have a workbook with 8 sheets. I have hidden two of the sheets and want to lock the rest from people editing, and stop them from unhiding the hidden sheets
I go to tools>protection > protect workbook
After typing in the password this doesnt protect the workbook as i am still able to edit the cells.
how to lock the all sheets and stop them from being edited?
View 9 Replies
View Related
May 22, 2013
I have some VBA code that crates a PDF saves it in a direcory gained from Cells in Sheet and i now wanto to email that saved PDF but it keeps coming up with file path not recognised or found.
Code:
Sub saveandclose2()
Dim MyPath As String
Application.DisplayAlerts = False
[Code]....
View 4 Replies
View Related
Dec 3, 2008
I have created a pop up calendar using VBA with the help of VBA Tips at www.fontstuff.com/vba and it works very well. However it has the default date of 12 March, In the tutorial that i used there was some code to use todays date if the cell (in which i was going to put a date) is empty. Which is as follows
Private Sub UserForm_Initialize()
If IsDate(ActiveCell.Value) Then
Calendar1.Value = DateValue(ActiveCell.Value)
Else
Calendar1.Value = Date
End If
End Sub
yet when the calendar does pop up, the date remains at 12 March (the calendar in the visual basic editor reflects the date correctly). I've tried to change numerous amounts of properties, without success
View 9 Replies
View Related
Apr 5, 2013
When you use a basic function like SUM, you see SUM(number1,[number2],...). The "number1,[number2],..." using the function.
Now when using a function you create (e.g. below)
VB:
Function euro(dolar) As Double
euro = dolar * 1.2
End Function
When I type =euro in a cell in excell, i dont get the indication euro(dollar).
Is it possible to activate this option in a way or another?
View 1 Replies
View Related
Mar 25, 2014
I've created a macro which copies the current tab to a new workbook (Book X):
[Code]....
I then manipulate the copied data in Book X. Once this is done I move the manipulated sheet back into original file
[Code] .......
The problem i'm having is I'd like to close the newly created Workbook X file once the macro has run but Workbook X is usually called Book2, Book4, Book7, Book32 etc.
Workbook X will always be the previous file if i use the ALT TAB shortcut.
View 2 Replies
View Related
Nov 24, 2008
I am trying to create a function in VBA that will return a range, but I don't want the range to point to cells on a spreadsheet. I want the range to return a vba created range. Is this possible or impossible? Is a variable of type range required to point to cells on a spreadsheet?
View 14 Replies
View Related
Jul 21, 2009
I originally posted this in the "Excel New Users forum" - i guess that was an error, but I'm very new (second post) and very new to VBA in general - so please be gentle!!
I've created a macro which opens a workbook, creates and renames a new worksheet, and moves it to the end of the workbook.
I then need to paste into this new worksheet a selection from another workbook.
How would I specify in the code that the selection needs to be pasted into the newly created tab?
View 12 Replies
View Related
Oct 21, 2009
I am trying to create a file which will contain several thousand links to files which will not be created for some time. It's purpose is to trend KPI's and budget compliance over time. Is there a way to create these links in Excel 2007 without having to cancel the annoying "Update Valeus" window? Here is an example of that is looking for a file that will be created in 2 weeks.
=IF(AND(ISNUMBER(MATCH(B12,'V:MaintenanceWork ManagementPublicWork Management KPIsSAP SchedulingJobs With Operations In The Past[Jobs with Operations In The Past 11-4-09.xlsx]Plant Section Sort'!$B:$B,0)),(ISNUMBER(MATCH(I12,'V:MaintenanceWork ManagementPublicWork Management KPIsSAP SchedulingJobs With Operations In The Past[Jobs with Operations In The Past 11-4-09.xlsx]Plant Section Sort'!$I:$I,0)))),"Duplicate","New")
View 3 Replies
View Related
Feb 10, 2010
I've tried declaring my object variable (TabOrder) as module-level within a Sheet Module and also as local within a Subroutine in the Sheet Module. In both cases, when the debugger steps through the code, the object is destroyed almost as soon as it is created.
View 4 Replies
View Related