Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Excel Locked Up
I created an Add-In Using Excel 2003, maintained in a password-
protected project and have had many people using it without any problems. However, I have given it to a new user and it causes the entire Excel application to stop functioning. The user tells me that none of his menu bars work and the only option he has it to close the application. Could this be because he may be using a different version of Excel than which I created the add-in from? Or, something else, perhaps? Thanks for your help. Coby. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Excel Locked Up
Coby,
You don't provide enough information for anyone to provide any real help. The answers to your two questions are... Yes and Yes. Posting your code along with the Excel version on the problem machine would get things going. You would also need to explain in general terms what your code is intended to do. (including if it modifies toolbars/menubars) Note that Excel 2007 does not have a menubar or toolbars. Also, there should be error handling in code provided to others to use. The errors displayed would have been the place to start to in determine the problem. Starting fresh in a new post with the extra information may be the way to go. This post now has an answer (mine) and others may ignore additional questions posted to it. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message I created an Add-In Using Excel 2003, maintained in a password- protected project and have had many people using it without any problems. However, I have given it to a new user and it causes the entire Excel application to stop functioning. The user tells me that none of his menu bars work and the only option he has it to close the application. Could this be because he may be using a different version of Excel than which I created the add-in from? Or, something else, perhaps? Thanks for your help. Coby. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Excel Locked Up
On Jun 2, 6:04 pm, wrote:
I created an Add-In Using Excel 2003, maintained in a password- protected project and have had many people using it without any problems. However, I have given it to a new user and it causes the entire Excel application to stop functioning. The user tells me that none of his menu bars work and the only option he has it to close the application. Could this be because he may be using a different version of Excel than which I created the add-in from? Or, something else, perhaps? Thanks for your help. Coby. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Excel Locked Up
On Jun 2, 7:22 pm, "Jim Cone" wrote:
Coby, You don't provide enough information for anyone to provide any real help. The answers to your two questions are... Yes and Yes. Posting your code along with the Excel version on the problem machine would get things going. You would also need to explain in general terms what your code is intended to do. (including if it modifies toolbars/menubars) Note that Excel 2007 does not have a menubar or toolbars. Also, there should be error handling in code provided to others to use. The errors displayed would have been the place to start to in determine the problem. Starting fresh in a new post with the extra information may be the way to go. This post now has an answer (mine) and others may ignore additional questions posted to it. -- Jim Cone Portland, Oregon USAhttp://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message I created an Add-In Using Excel 2003, maintained in a password- protected project and have had many people using it without any problems. However, I have given it to a new user and it causes the entire Excel application to stop functioning. The user tells me that none of his menu bars work and the only option he has it to close the application. Could this be because he may be using a different version of Excel than which I created the add-in from? Or, something else, perhaps? Thanks for your help. Coby. Yes. Your response was very helpful and has lead me to solve the problem. You mentioned error handling, I looked it up, implemented it, encountered a problem and fixed it from there. This is why the forum is great. I was vague because the user had provided me with very little info to go off of, you didn't feel you could be very helpful, yet you lead me to the solution. For that, I thank you Jim Cone. And, below is my code where I forgot to set my XlTools variable because I was jumping over it with a GoTo command. Thanks, again. Coby. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Excel Locked Up
On Jun 3, 6:53 am, wrote:
On Jun 2, 7:22 pm, "Jim Cone" wrote: Coby, You don't provide enough information for anyone to provide any real help. The answers to your two questions are... Yes and Yes. Posting your code along with the Excel version on the problem machine would get things going. You would also need to explain in general terms what your code is intended to do. (including if it modifies toolbars/menubars) Note that Excel 2007 does not have a menubar or toolbars. Also, there should be error handling in code provided to others to use. The errors displayed would have been the place to start to in determine the problem. Starting fresh in a new post with the extra information may be the way to go. This post now has an answer (mine) and others may ignore additional questions posted to it. -- Jim Cone Portland, Oregon USAhttp://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message I created an Add-In Using Excel 2003, maintained in a password- protected project and have had many people using it without any problems. However, I have given it to a new user and it causes the entire Excel application to stop functioning. The user tells me that none of his menu bars work and the only option he has it to close the application. Could this be because he may be using a different version of Excel than which I created the add-in from? Or, something else, perhaps? Thanks for your help. Coby. Yes. Your response was very helpful and has lead me to solve the problem. You mentioned error handling, I looked it up, implemented it, encountered a problem and fixed it from there. This is why the forum is great. I was vague because the user had provided me with very little info to go off of, you didn't feel you could be very helpful, yet you lead me to the solution. For that, I thank you Jim Cone. And, below is my code where I forgot to set my XlTools variable because I was jumping over it with a GoTo command. Thanks, again. Coby. Sub Mount_CoreConsole() Dim Ms As CommandBarControl Dim amb As CommandBar Dim XlTools As CommandBarPopup Dim CoreCons As CommandBarButton Dim T As Long On Error GoTo Err_Handle Application.ScreenUpdating = False Set amb = CommandBars.ActiveMenuBar For Each Ms In amb.Controls If Ms.Caption = "&Jonce Thomas Tools" Then T = Ms.Index GoTo Mount_Core End If Next 'INSTALL A TOOLS MENU if MsExcel Doesn't have one Set XlTools = amb.Controls.Add(Type:=msoControlPopup, Temporary:=True) XlTools.Caption = "&Jonce Thomas Tools" Set XlTools = amb.Controls("&Jonce Thomas Tools") 'Mount Core Console to Tools menu Mount_Co 'LL SORT BUTTON Set CoreCons = XlTools.CommandBar.Controls _ .Add(Type:=msoControlButton, ID:=1) With CoreCons .Caption = "Sort Long List" .TooltipText = "Sorts Jonce Thomas Construction Long List" .Style = msoButtonCaption .OnAction = "SortLongList" End With 'About BUTTON Set CoreCons = XlTools.CommandBar.Controls _ .Add(Type:=msoControlButton, ID:=1) With CoreCons .Caption = "About Version" .TooltipText = "" .Style = msoButtonCaption .OnAction = "Pop_VersionInfo" End With Err_Handle: MsgBox Err.Number & " " & Err.Description End Sub Thanks for your help. Coby. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
locked cell not locked | Excel Discussion (Misc queries) | |||
Need to know who has excel file locked | Excel Programming | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
I want the macros to be locked up when cells are locked up. | Excel Programming |