Removing a command from a Menu (Excel 2000)

Topic

New Reply

Hi All
I have my users enter data in a Shared Workbook. Is there a way that I can prevent the users from turning off the Sharing. I thought it could be done by removing the command from the menu? Any help would be appreciated and thanks!
–cat

Reply | Quote

Replies

Customizations to toolbars and menus are user-level settings, not workbook-level settings. You would have to write code that disables the Share Workbook… menu option when the workbook is activated, and enables it when the workbook is deactivated. But users with a bit of knowledge of VBA could easily circumvent this.

Do you really need the workbook to be shared? I have only heard negative things about it – it is a source of wrokbook corruption.

Reply | Quote

<>
Gets in everywhere, dunnit!

Tony.

Reply | Quote

Who needs a speling chekker?

Reply | Quote

Eye no eye knead won.

Steve

Reply | Quote

Eye no eye knead won.

Steve

Reply | Quote

Who needs a speling chekker?

Reply | Quote

<>
Gets in everywhere, dunnit!

Tony.

Reply | Quote

Customizations to toolbars and menus are user-level settings, not workbook-level settings. You would have to write code that disables the Share Workbook… menu option when the workbook is activated, and enables it when the workbook is deactivated. But users with a bit of knowledge of VBA could easily circumvent this.

Do you really need the workbook to be shared? I have only heard negative things about it – it is a source of wrokbook corruption.

Reply | Quote

Cindy,
Hans is right – I speak from experience. Sharing does lead to wrokbook problems. The sharing option keeps a log of changes and bloats the file, slowing things down, especially when loading it across a network. We eventually removed Sharing from many Excel files in my organization.

Can you arrange for the users to use the file one at a time? Excel does pop up a little question dialog when the file is already open, with one option to notify the “new” user when the current user is done.

Errol

Reply | Quote

Cindy,
Hans is right – I speak from experience. Sharing does lead to wrokbook problems. The sharing option keeps a log of changes and bloats the file, slowing things down, especially when loading it across a network. We eventually removed Sharing from many Excel files in my organization.

Can you arrange for the users to use the file one at a time? Excel does pop up a little question dialog when the file is already open, with one option to notify the “new” user when the current user is done.

Errol

Reply | Quote

As much as I’m against sharing (!!!!!!!!!), there is an option to protect and share a workbook: Tools, Protection, Protect and share workbook. Dunno what features get blocked exactly though.

Reply | Quote

As much as I’m against sharing (!!!!!!!!!), there is an option to protect and share a workbook: Tools, Protection, Protect and share workbook. Dunno what features get blocked exactly though.

Reply | Quote