jmaocubo
01-30-2013, 08:10 AM
Hi
I created a project where all actions are performed in userforms.
This project will be placed on a server and will be used by multiple users.
two questions:
1) the interface was intended only userforms. To use this I thought
Thisworkbook.application.visible = false and in the exit button Thisworkbook.application.visible = true
thisworkbook.close savechanges:=true
unload me The problem is that all open workbooks also become hidden.
Is there any way to just stay hidden ThisWorkbook?
2) the workbook will be used by multiple users, but one at a time.
Is there any way when the workbook is opened by a user in his workpost pop up an alert to another user who is trying to open the workbook that it is open and can not make any changes? then this workbook.close (until no one is using it)
Thanks in advance
Miguel
I created a project where all actions are performed in userforms.
This project will be placed on a server and will be used by multiple users.
two questions:
1) the interface was intended only userforms. To use this I thought
Thisworkbook.application.visible = false and in the exit button Thisworkbook.application.visible = true
thisworkbook.close savechanges:=true
unload me The problem is that all open workbooks also become hidden.
Is there any way to just stay hidden ThisWorkbook?
2) the workbook will be used by multiple users, but one at a time.
Is there any way when the workbook is opened by a user in his workpost pop up an alert to another user who is trying to open the workbook that it is open and can not make any changes? then this workbook.close (until no one is using it)
Thanks in advance
Miguel