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.

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,
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

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,
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

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

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

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.

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.