Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default user can't use workbook when already open

Hi I have a workbook with forms and code modules, the workbook has a password
on it to open and for the code window. The problem I have is that if the book
is open by a user another user can open it and with an error can't find code
module, when the user closes the book then then another user can then open it.
Has anybody had this problem before and is there anything I can do to fix it?.
Regards
Charles
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 253
Default user can't use workbook when already open

Hi,

try to debug it and send theline of code that gives the erro.
Unprotect your project first.
Regards
JY

"vqthomf" wrote in message
...
Hi I have a workbook with forms and code modules, the workbook has a
password
on it to open and for the code window. The problem I have is that if the
book
is open by a user another user can open it and with an error can't find
code
module, when the user closes the book then then another user can then open
it.
Has anybody had this problem before and is there anything I can do to fix
it?.
Regards
Charles



Reply
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
how can i know the last user who open the workbook Sebation.G[_2_] Excel Programming 2 May 13th 07 01:15 PM
Identifying the user that has a workbook open? DS Excel Programming 2 April 17th 07 08:54 AM
Open workbook in user-defined folder pdberger Excel Programming 4 August 30th 05 09:39 PM
Check For Open Workbook by another User Mark Excel Programming 1 November 6th 03 03:45 AM
Excel not warning if another user has the workbook open Edward Chalk Excel Programming 2 July 21st 03 06:18 AM


All times are GMT +1. The time now is 07:27 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"