Spreadsheet Open But Not Visible. Hidden

Nov 8, 2006

I was working on a multi-tab spreadsheet (7 tabs to be exact) and I went to hide one of the tabs and all of a sudden the worksheet went away and I was left with my empty personal.xls spreadsheet. If I go into tools and visual basic I see my spreadsheet listed as VBAProject (Durex Sales Oct 1 to Oct 28 06.xls) with the 7 sheets listed below it within a folder called Microsoft Excel Objects, but I can't get it back in spreadsheet form.

View 5 Replies


ADVERTISEMENT

Visible Sheets To Be Hidden With The Exception Of The Sheet Called "open". Then Is Saves The File

Sep 9, 2008

i am using the macro below to get excel to hide all sheets but the one called "open"...

PHP
Sub savemini()

ActiveWorkbook.Unprotect "letmein"

  For Each sh In ThisWorkbook.Worksheets
       If Not sh.Name = "open" Then sh.Visible = xlVeryHidden
   Next sh

    ActiveWorkbook.Save
End Sub 

So the workbook is protected with the password "letmein", and the VB code above in theory should unlock the workbook, allowing all visible sheets to be hidden with the exception of the sheet called "open". Then is saves the file.

Now heres the odd bit... it works for certain people, but not for others. I have made sure those it wont work for are not doing anything weird and they are not.

The workbook i am using has a code that only opens certain sheets for certain users. I as a master user have access to all sheets. I can go into the users sheets and click the button that activates the macro above myself and it works fine, but for some users it wont work.

View 9 Replies View Related

Format All Cells In All Sheets To Protection Hidden On Visible And Hidden Tabs

Feb 28, 2014

I am trying to format all cells on all sheets (hidden or otherwise) as "Locked" so when the sheets are protected the user can't see the formulas. This macro individually selects every sheet in the book and applys the formatting. Is there a way to modify this code to accomplish the same thing without having it actually select every sheet? The only reason it is an issue is that after running the macro you end up on the last sheet in the book.

View 7 Replies View Related

Hidden/Visible Sheets In Listbox

Sep 22, 2009

I'm trying to create a userform that allows the user to swap sheets from visible to hidden status. I've made it to the point where all the sheet names are populated based on their current status in their respective listbox, but I am stuck on using the results of any swaps to newly set their visible property. the code I have in the userform is as follows:

View 2 Replies View Related

LastRow Needs To Select Next VISIBLE Row (not Hidden Row)

Jul 19, 2007

I'm having a problem moving the cell cursor 2 rows down once I find my LastRow (see LastRow code below). My problem is I need to move down 2 VISIBLE Rows down and I'm running into it moving 2 Rows down whether they are Visible or Hidden? If Row 50 is my LastRow, and I have it move 2 rows down, if Row 52 is Hidden, it still moves to Row 52 which can't be seen by the user after I do my stuff to that row? I can't unhide any hidden rows for other reasons. Is there a way to have the cursor move down 2 VISIBLE Rows instead of 2 Rows regardless?

The code I use to select the LastRow is:

LastRow = Cells(4000, 8).End(xlUp).Row
I move down 2 more rows using:

Cells(LastRow + 2, 8).Select 'Then I do some stuff here for the user, so it can't be a hidden row

View 9 Replies View Related

Toggle 2 Subs (between Either Hidden Or Visible Menus)

Dec 11, 2013

I would like to toggle (button) between either hidden menus or visible menus. I have the following code:

Private Sub ToggleButton1_Click()
With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual

[Code] .......

Will not work. either one state or the other is visible.

View 2 Replies View Related

Change Textbox Border Color - Visible Or Hidden

Mar 8, 2012

What command I would use to change the text box border color, and set text border to visible or hidden?

View 3 Replies View Related

Open Second Spreadsheet Minimized On Open Of Spreadsheet + More

Oct 27, 2009

I have a spreadsheet that on open needs to open a 2nd spreadsheet minimised and delete 2 named sheets in the 2nd spreadsheet.

On close of the first spreadsheet it should then copy 2 sheets with the same name from itself into the 2nd spreadsheet.

This is to start a spreadsheet that will track project risks and issues that I will post further details for as other functions are required.

View 9 Replies View Related

Determine Which Rows In Spreadsheet Hidden?

Sep 27, 2011

Is there an easy way to determine which rows in a spreadsheet are hidden, rather then scrolling through manually and trying to find nonsequential row numbers?

View 1 Replies View Related

Open A Workbook With Only One Sheet Visible.

Mar 10, 2009

How do I get a workbook to open with a selected sheet visible, or preferably all hidden? I already have a userform that opens upon opening the workbook that the user 'Enters' the workbook with.

My untidy method would have been to use an If -Then statement for each sheet in the Private Sub Workbook_Open. Is there a neater way of doing it?

View 6 Replies View Related

Open Workbook Without It Being Visible Using A Button

Jun 19, 2002

I want to open a workbook, using a button, but I don't want the workbook to be visible. I'm looking for something similar to the visible = false that you can use when opening a database file. If I use the visible = true command after the workbooks.open command, it hides the workbook that the the code is in and not the one that the code is opening.

Currently I'm just using the workbooks.open command, but I just want the file I'm opening to open in the background.

View 6 Replies View Related

Keep UserForm Visible While Other Workbooks Are Open

Oct 15, 2006

I have a workbook with 'Application.Visible = False' in the 'Workbook
open' event, as well as 'Userform1.show'. The relevant Desktop shortcut
is set up for the application to run 'Minimized' and to start in
"C:Program FilesMicrosoft OfficeOFFICE11".

In this manner, when the shortcut is Dbl clicked, the userform appears
with no visible evidence of Excel having been started. The
application.visible attribute is reset in the 'workbook close' event
with :"Application visible = true.

All of this works extremely well, however wilst previously opened
workbooks remain open and visible when I start this workbook, while the
workbook is opened I an unable to start any other excel workbook via
their shortcuts. I can however start a new instance of Excel then
browse to the workbook to open it.

MY QUESTION: How do I allow users to start any of their Excel
workbooks via their shortcuts while my application is running and the
userform showing?

View 6 Replies View Related

Delete Adjacent (hidden) Data When Deleting Visible Data

Dec 10, 2009

I have 3 columns of data that are being copied from a .csv file. The data is pasted into Columns B, C, & D. Columns C and D are hidden. So that the user does not have to unhide the columns in order to delete the data, I would like to make it so that when the data in column B is deleted, the data in columns C and D is also deleted.

View 14 Replies View Related

Open The Hidden Worksheet When Clicked

May 2, 2006

1) I cannot figure out how to write VBA so the "Show Results" button will open the hidden worksheet when clicked.

2) When I use the userform to add new info, it does save to the worksheet, but when I cose the userform and try to open the spreadsheet, I get the following message, "Userform is already opened. Reopening will cause any changes to be disguarded". If I answer yes, I lose my changes, if I answer no, the changes are saved. I want this message to go away and data from the userform to automatically be added to the spreadsheet.

3) I want to make sure the "Account Number" field has a 9 digit number in it before it can be saved. If there is not a 9 digit number I would like an error message saying "Please enter a 9 digit account number" as a pop up.

4) I want to make sure both the "Account Number" and the "Assignment" fields have been populated before the data can be saved.

View 9 Replies View Related

Keep Hidden Sheet Made Visible As Active Sheet

Mar 2, 2007

I have a button on a sheet that runs a macro to unhide another sheet. That works, but I want the sheet made visible to remain forward. Instead, the button unhides the sheet and the sheet the button is on comes forward again. I am unable to figure how to keep the sheet made visible forward. Here is the macro 'as recorded'.

Sub UnhideSheet1()
Sheet2.Visible = True
End Sub

View 7 Replies View Related

Open Hidden Sheet With Clicking Button?

Aug 23, 2013

I have a workbook including several sheets.

I'd like to hide all worksheets and in the excel there is only one visible sheet which is Navigation Page. I want to add several buttons on this sheet and each button will be clicked to call the other sheets.

For example, there is a sheet called Sales_Approval_Form and I'd like to add a button on navigation page called Sales Approval Form and when the user clicks the button the sheet will be open for entering data.

View 12 Replies View Related

How To Have Open Hidden Sheet / Hide On Closing

Feb 24, 2014

I've got this function where you can select from a list of names, and when you press go it unhides the sheet and goes to it, problem with that was after closing the sheet it was no longer hidden. So now, I have

[Code]......

So when you press go, it unhides the sheet, goes to it, and hides it again, but then the sheet is hidden it pushes the user back to the page they was on, so it would appear you can't have a hidden sheet open.

Is there a way for excel to determine when the sheet has been closed, to be able to hide it when the user navigates away?

View 6 Replies View Related

Automatically Check For Existence Of Hidden Sheet Upon Open

May 1, 2009

I use the code below to check and see if a sheet exists or not when a workbook is opened. If it does not, continue. If it does I need to run a different sub on it.
Twist, I need to check for a hidden sheet. How would I chg the code to do this?

Private Sub Workbook_Open()
'Also need to check the code in the userform. Has On.Time command.
'SplashForm.Show
Sub Sheet_Test_1()
Dim sh As Worksheet
On Error Resume Next
Set sh = ActiveWorkbook.Sheets(" total")
If Err.Number <> 0 Then
MsgBox "The sheet doesn't exist"
Err.Clear
On Error Goto 0
Else
MsgBox "The sheet exist"
End If
End Sub

View 5 Replies View Related

Hide Column(s) But Still Have Data In That Column Be Visible At Bottom Of Spreadsheet

Jun 23, 2014

I was wondering if it is possible to hide a column(s) but still have data in that column be visible at the bottom of the spreadsheet. For example, if I hide column G can it only hide the column from rows 1 - 50 and then the column will appear after row 50?

View 3 Replies View Related

Open An Spreadsheet Except Through The Application

Dec 16, 2008

I cannot open an Excel spreadsheet except through the Excel application. This includes through Windows Explorer, on the internet (this forum), in email. I need to save the file first, then open Excel, then open (through Excel) the file.

In Email, I get "System cannnot find the file specified" On this site, I get "Access to the specified device/path is denied" From Explorer, "Cannot find the file.... based on the criteria xls(or one of its components). Make sure the path and file name are correct and that all required libraries are available."

Last time, our IT group couldn't fix it and had to reinstall the entire Office package to get it working again. I'd rather not go through that.

View 2 Replies View Related

Password Box For Spreadsheet Open

Apr 19, 2006

I am just wondering if it is possible to insert a module or a code such that it is user specific.

In detail, there are two types of users: Administrator and User.

If it were administrator, it should ask for a password. If user, it should give the read-only or a protected form of the spreadsheet.

I just need the workbook to pop-up with a msgbox of administrator/user with a radio button or a select button. If administrator, it should ask for a password. Also, disabling the macros should not open the spreadsheet as making this would lead to nothing.

View 3 Replies View Related

Popup If Condition On Spreadsheet Open

May 18, 2007

I would like to have a popup appear on the opening of my spreadsheet that warns me of things that are past due or due today. I would like it to be in list form...

For example my source is:
Customer 1 Customer 2
Topic Expected Complete Expected Complete

One 05/18/2007 05/10/2007
Two 05/12/2007 05/15/2007 05/18/2007 05/18/2007
Three 05/12/2007 05/17/2007 05/16/2007
Four 05/21/2007 05/17/2007

What I would like to see is a popup that analyzes this data with the result of:

If run today...5/18...................................

View 14 Replies View Related

Open A Spreadsheet From Command Button

Jan 26, 2009

I have an excel sheet that has 3 command buttons on it, i am wanting to open a saved excel sheet that i have on my shared drive from the command button. I know the path of the saved file but how do i get the button to open this file?

As well as this i this i also have another command button what i want to open another sheet in the excel document with the command buttons.

View 5 Replies View Related

Open And View The Contents On The Spreadsheet

Jan 30, 2014

I have a Excel Addin file which i would like to open and view the contents on the spreadsheet

View 1 Replies View Related

Open Userform When You Close A Spreadsheet

Mar 5, 2007

I've got a 'Control Panel' spreadsheet which is all based on UserForms. When a user clicks a particular button, it opens one of many separate 'Regional' sheets which they work in.

When the user closes the 'Regional' sheet, I would like the 'Control Panel' sheets userforms to show again. However I can find no way of doing this as it simply switches back to the 'Control Panel' sheet without loading the forms (as I had to hide the 'Control Panel' useforms to give them access to the 'Regional' sheet).

View 9 Replies View Related

Loop To Open Spreadsheet With Varying Name

Mar 24, 2009

I'm especially having trouble with loops. I'm a little dense in that department. Here is what I am trying to do. I open 3 spreadsheets. I want to consolidate them into one of the spreadsheets. The first obstacle I face is that one of the spreadsheets has a name which varies. It is always called either "PLR.xls" or "PendingLoans.xls". Also, it will have a number at the end depending on how many excel books have been opened so far in the day, i.e. "PLR (2).xls" or "PLR (5).xls". At this point, all I want to do is be able to select this file consistently. I currently have something like this (excuse my syntax - its saved at work and like I said, I'm still learning VBA).

View 4 Replies View Related

Open Spreadsheet To Specific Worksheet

May 24, 2012

There used to be a way to open an Excel spreadsheet and have it go to a specific sheet....... I want to open Grants.xls and have it always go to the "index" sheet....

View 3 Replies View Related

How To Open Password Locked Spreadsheet

Jun 18, 2013

I inherited a spreadsheet from a recently let go co-worker. This spreadsheet has a lot of important financial data on it, so I really need to get into the spreadsheet. we contacted the former employee and he said he forgot the password. Is there any work around to get into the sheet?

View 2 Replies View Related

Work In Spreadsheet While Userform Is Open

Mar 20, 2008

Problem: I have textbox entries that are part of a Userform that opens using a macro on a speadsheet button. Once this form is open, I can no longer actively work in the spreadsheets.

Need: I need a way to minimize or "put on hold" the Userform so that I can freely move around in the spreadsheet. This could be in the form of a button on the Userform. Then, I need a way to bring back this userform to the point I was at before being put on hold so that I can continue to input entries into the textboxes (again, a buttton that could bring it back). There should be a way to toggle between both worlds.

View 2 Replies View Related

Reference Another Spreadsheet To Open Within Excel Using A Command?

Jun 18, 2014

I want to have 2 spreadsheets in File 1.

The first spreadsheet will contain a form that needs to be filled out by a user for a specific car. In the second spreadsheet, I want to have a list of the cars that have already been filled out in a form before.

So example, someone with a car got into an accident and the report is filed under vin:1234 and vin:1234 is added to the list in the second spreadsheet.

A couple days later another accident report is written up, but when the user enters vin:1234 in the form, it will notify the user that vin:1234 has a report already written up on it. The notification also asks if they want to open the file containing vin:1234. When they click 'yes', it will open the file and allow them to either use the current report for their own, or modify what was already entered.

Is this possible to do within excel? I would constantly update spreadsheet 2 with the vins that have been used to keep it as a database.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved