LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Disable share workbook option in VBA

I've got a workbook with a lot of code and want to prevent users from
sharing the workbook. If they share the workbook, it only generates
error messages for them and creates problems.

If I could hide the command bar option or catch when they go to share
the workbook and cancel the action, that would be great. But I
searched high and low on how to do this with no luck. Users will be
using XL 2002 up to 2007. Does anyone have any ideas or faced this
challenge before?

Les
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable print option of a worksheet/workbook Nelly07 Excel Discussion (Misc queries) 0 October 23rd 07 10:19 PM
Save-As Option Disable Salman Excel Worksheet Functions 0 January 9th 07 12:09 PM
How can I share and un-share a workbook using a macro? Botter Excel Programming 2 October 4th 06 06:39 PM
Can't share workbook. The "Share Workbook" option is off. Why? Doyle Diener Excel Discussion (Misc queries) 4 April 24th 06 06:56 PM
How to disable smoothline option. Sureshkrishnan Charts and Charting in Excel 2 October 15th 05 01:47 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"