Home |
Search |
Today's Posts |
#1
|
|||
|
|||
right click on objects not working
Hi,
I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. |
#2
|
|||
|
|||
Is the worksheet protected?
Is the workbook shared? Anthony wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. -- Dave Peterson |
#3
|
|||
|
|||
Dave,
If you meen under Tools-Protection, I have not protected the workbook/worksheet, so that isn't the problem - as far as I can see. Cheers Anthony "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Anthony wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. -- Dave Peterson |
#4
|
|||
|
|||
How about tools|share workbook?
(or do you see [Shared] in the title bar?) One more guess... Do you have multiple worksheets selected--do you see [Group] in the title bar? Anthony wrote: Dave, If you meen under Tools-Protection, I have not protected the workbook/worksheet, so that isn't the problem - as far as I can see. Cheers Anthony "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Anthony wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Dave,
On Tools / share workbook I have the 'Allow changes by more than one user at a time' box unchecked, and the title bar shows 'Exclusive' - that is if I'm looking at the correct place - being a novice and all. "Dave Peterson" wrote: How about tools|share workbook? (or do you see [Shared] in the title bar?) One more guess... Do you have multiple worksheets selected--do you see [Group] in the title bar? Anthony wrote: Dave, If you meen under Tools-Protection, I have not protected the workbook/worksheet, so that isn't the problem - as far as I can see. Cheers Anthony "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Anthony wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
It sounds like the workbook isn't shared--so that's not it.
Did you look at the [group] question? (I'm out of guesses...) Anthony wrote: Dave, On Tools / share workbook I have the 'Allow changes by more than one user at a time' box unchecked, and the title bar shows 'Exclusive' - that is if I'm looking at the correct place - being a novice and all. "Dave Peterson" wrote: How about tools|share workbook? (or do you see [Shared] in the title bar?) One more guess... Do you have multiple worksheets selected--do you see [Group] in the title bar? Anthony wrote: Dave, If you meen under Tools-Protection, I have not protected the workbook/worksheet, so that isn't the problem - as far as I can see. Cheers Anthony "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Anthony wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
well many thanks for trying,
cheers Anthony "Dave Peterson" wrote: It sounds like the workbook isn't shared--so that's not it. Did you look at the [group] question? (I'm out of guesses...) Anthony wrote: Dave, On Tools / share workbook I have the 'Allow changes by more than one user at a time' box unchecked, and the title bar shows 'Exclusive' - that is if I'm looking at the correct place - being a novice and all. "Dave Peterson" wrote: How about tools|share workbook? (or do you see [Shared] in the title bar?) One more guess... Do you have multiple worksheets selected--do you see [Group] in the title bar? Anthony wrote: Dave, If you meen under Tools-Protection, I have not protected the workbook/worksheet, so that isn't the problem - as far as I can see. Cheers Anthony "Dave Peterson" wrote: Is the worksheet protected? Is the workbook shared? Anthony wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
|
|||
|
|||
Any chance you have an add-in loaded that modifies the right-click action?
Essbase, for instance, can cause this type of behavior, but has settings to allow you to turn it off. "Anthony" wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. |
#9
|
|||
|
|||
Duke,
oh...err....sorry bit of a novice, how wud I check if any addins loaded? thanks "Duke Carey" wrote: Any chance you have an add-in loaded that modifies the right-click action? Essbase, for instance, can cause this type of behavior, but has settings to allow you to turn it off. "Anthony" wrote: Hi, I am trying to asaign a macro to an inserted picture or even an object buit the right click doesn't work. I have done the following when I couldn't right click anywhere but I still can't get it to work on the pics/objects..here is what I did before Opened the VB Immediate window and typed application.commandbars("Cell").enabled = true any help apreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should pan like autocad (click and hold wheel). | Excel Discussion (Misc queries) | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
My right click menu is not working. | Excel Discussion (Misc queries) | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions |