PDA

View Full Version : application.hide and opened file by two users



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

Aussiebear
01-30-2013, 04:42 PM
Please start a another thread relating to the 2nd question

jmaocubo
02-01-2013, 03:16 AM
Please start a another thread relating to the 2nd question

Sorry:doh:

2nd question thread: http://www.vbaexpress.com/forum/showthread.php?t=45195