Solved

ThisWorkbook.Windows(1).Visible = False

Posted on 2013-06-04

1 solution

Medium Priority

953 Views

Last Modified: 2013-06-07

Hi,

I have a form named 'LoginFrm' in the workbook named 'Forecast.xlsm'. I have written the below code in workbook_open() event.

 Private Sub Workbook_Open()

ThisWorkbook.Windows(1).Visible = False
LoginFrm.Show

End Sub

Open in new window

This will disable the user to access the worksheets which are there in this workbook. However, if there are already workbooks open (i am referring to other workbooks) then when I open this workbook (Forecast.xlsm) then this code will disable the user in accessing other opened workbooks also. Ideally, the user should be able to access other workbooks other than 'Forecast.xlsm'. Please advise.

Thank you,
Prashanth

Comment

Question by:pg1533

4 Comments

LVL 77

Expert Comment

by:GrahamSkan

ID: 392212012013-06-04

It might be because all the workbooks are in the same instance and share the same window.
EE's sister site online-tech-tips has a registry patch for creating multiple instances in this article:

http://www.online-tech-tips.com/ms-office-tips/how-to-open-a-new-instance-of-excel-2007-workbooks/

Or there is discussion in a recent question here:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28070937.html

LVL 23

Expert Comment

by:Michael Fowler

ID: 392217472013-06-05

Instead of making the windows not visible why not set all tabs to xlVeryHidden and then once the user has logged on then loop through and make them visible. You would also add a before save script to hide them before the workbook is saved.

Michael

LVL 23

Accepted Solution

by:Michael Fowler

Michael Fowler earned 2000 total points

ID: 392218012013-06-05

Here is an example of what you could do

Michael
Book1.xlsm

Author Closing Comment

by:pg1533

ID: 392301432013-06-07

Thank you

Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment Already a member? Login.

My Favorite Code Snippets

Article by: Martin

This article presents several of my favorite code snippets.

Debits & Credits. Why oh why do they exist?

Article by: Anthony

Here is why.

How to use the IF function in Excel

Video by: Bob

Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

Microsoft Excel

How To Make a Graph with Microsoft Access

Video by: crystal

Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…