Protected Zoom Level For All Sheets For All Users?

Dec 22, 2013

I've created a shared spreadsheet with multiple sheets. All the content was created to be visible without having to scroll at 87%. My question is can I protect or lock the zoom level so that when anyone else opens the spreadsheet, it will only be visible at 87%? I have my screen resolution at "Smallest" so not sure if that too will affect the viewing level.

View 7 Replies


ADVERTISEMENT

Synchronize Scroll And Zoom Level Across Sheets Automatically

Feb 4, 2013

I'm looking for a code to have all the sheets in my workbook scroll together and adjust their zoom level. For example, if I zoom to 70% on Sheet 1 and scroll down to display cell J93 in the bottom left corner, I would like Sheet 2 to also be at 70% and have J93 be at the bottom left corner when I click on it.

Preferably, I would like for the sheets to adjust accordingly only when I click on them and for the macro not to have to loop through each one whenever I change one sheet (my workbook has 52 sheets for weeks of the year, plus summary sheets, so it would be very draining for it to loop through each).

I've already found a macro to have the scroll match across sheets as I adjust and click on them, but I was hoping for a code that would incorporate synchronized zoom into it as well.

View 1 Replies View Related

Zoom Level Affects Shapes Positioning

Jun 30, 2008

Sub CreateRectangles()
X = 1
Do Until ActiveCell.Offset(X, X).Value = 0
X = X + 1
Loop
variable = Round(-0.026 * (X * X * X) + 0.56 * (X * X) + 24.7 * X + 5, 0)

Set Box = ActiveSheet.Rectangles.Add(ActiveCell.Offset(0, 0).Left, ActiveCell.Offset(0, 0).Top, variable, variable)

With Box
.ShapeRange.Fill.Transparency = 0.3
.Font.Size = 18
.Font.Name = "Trebuchet MS"
.Text = ActiveCell.NoteText

End With

End Sub

View 3 Replies View Related

Getting Data From MDB File Protected With User Level Permissions?

Aug 30, 2013

I need to get the data from an MDB file. No problems normally but in this case the MDB is protected with a workgroup file (MDW) from the old user level permissions that was available in Access.

Is it it possible to get data from the Data ribbon from a protected file or do I need to resort to vba?

View 1 Replies View Related

Protected Sheet Not Behaving The Same For All Users?

Mar 22, 2012

One of our password-protected shared workbooks is acting oddly, but only for one user. The protection is supposed to allow users to expand and collapse grouped columns using the "+" and "-" symbols on the sheet, and for most users it is; but one user is getting an error message that she can't perform that operation on a protected sheet. I've had her close and reopen the file and we have confirmed that she has the same version of Excel as the users who aren't having the issue (Excel 2007). This is a shared file on a server, not a local copy on her computer.

View 2 Replies View Related

How To Allow Users To Copy And Paste In Protected Sheet

Aug 13, 2014

Enabling users to copy and paste values in a protected sheet.

The sheet is protected because some of the columns are autopopulated based on formulas and I do not want someone to spoil the file.

Users are complaining that in many cases half of the information which they enter in one row have to be repeated in the nect 10 rows.

[Code] .....

is already in place to allow users to select and copy. How to enable them to paste in the same protected sheet?

View 2 Replies View Related

Unprotect Password Protected File For Other Users

Aug 12, 2013

I have a master file that generates a new file every time the master user run the macro. The macro is pasted here:

Code:
Sub NewWorkbook()
'
ThisWorkbook.Unprotect ("Password01#")

[Code]....

I want the new file to be opening without asking for any password at all. What am I supposed to include in the code for that?

View 9 Replies View Related

Allow Users To Insert / Delete Rows On A Protected Worksheet?

Apr 5, 2014

I have a worksheet that I have some "locked" cells on. I also have protected the worksheet but when I check to allow users to insert rows and to delete rows and then save it, when I re-open it I can't insert rows or delete rows???

I am using some VBA to allow for the collapseing of rows while maintaining protection and that works perfectly. I want users to be able to insert and delete rows while maintaining protection. I thought a simple check in the protection was good enough, but for some reason it isn't.

View 2 Replies View Related

Scroll & Zoom Sheets Simultaneously

Dec 8, 2006

I have a workbook of 6 Sheets, what i want is that if i scrolled or zoomed one of the sheets i want all other sheets to be scrolled and zoomed accordingly identically.

to explain more: say I'm on "sheet1" and I scrolled down so i'm seeing range(K225:X250), now if i switched to any of the other sheets i want them all scrolled to the same range. so whatever sheets i choose i want to see range(K225:X250) in the same viewing properties "zooming".

View 9 Replies View Related

Link Sheets Based On Grade Level.

Aug 31, 2009

I would like to link students for the 1st Nine Week list to the correct grade level as shown. I have attached a file.

View 2 Replies View Related

Zoom In By Using The ActiveWindow.Zoom Control

Nov 28, 2008

I know you can predefine the level of zoom you want by using the ActiveWindow.Zoom control. I'm trying to find some code to Zoom in by a particular percentage. For example +10% zoom, so if you are currently on 90%, excel zooms to 100%, click again and then get a zoom of 110%.

View 3 Replies View Related

Delete Chart Series Across Sheets But Skip Protected Sheets

Mar 30, 2008

I have received following macro from someone to delete series but the problem is that it gives error when some sheets are protected, and I want those sheets to protected. When run it will ignore/leave protected sheets but delete series only from unprotected sheets

Private Sub CommandButton1_Click()
Dim Rng As Range, i As Long, r As Range, lVal, uVal
Dim DeleteCount As Double
Dim lRow As Long
Dim dr As Long
Dim dc As Long
dc = Sheets("Deleted Numbers").UsedRange.Columns.Count - 1
dr = Cells(Rows.Count, Sheets("Deleted Numbers").UsedRange.Columns.Count - 1).End(xlUp).Row + 1
If dr = 60001 Then ................

View 4 Replies View Related

Multiple Users & Accounts Sheets

Jan 22, 2010

I’ve thought up a workbook with four sheets named “Employees Summary”, “EMP001”, “EMP002”, “EMP003” and a number of customer account sheets. Customer account sheets are named by their account numbers.

Now for the hard part. I will have three employees. All of us will have to login to the workbook with a username and password. Usernames would be. Administrator, EMP001, EMP002, EMP003. You should be able to change your password at any time.

All sheets will be visible to the administrator. Employees will only be able to see their respective “EMP” sheet and "Employee Summary" sheet. the rest is hidden. And the really hard part Every employee will enter all their transactions for the day into their respective sheets....

View 2 Replies View Related

Allowing Users To View Multiple Sheets Once Signed In?

Feb 24, 2014

What i am trying to do: Create a login option to filter what worksheets each user can see. I need the users to be able to view 2 sheets not just 1. Also i need an admin login that can view all sheets. I want to keep the workbook protected so even though they can see and edit those two sheets they can only edit certain unlocked cells. Admin should be able to view/edit all cells on all sheets.

Below is my code which is made for a sample workbook. I was just trying to get the concept down and then i would convert it to the real workbook.

Form Code:

[Code].....

View 2 Replies View Related

How To Allow Users To Add / Delete Rows / Columns In Sheets With Macros

Mar 11, 2014

I have a sheet with macros that allows users to fill in data from columns F10 to O10 from row 10 to 54.

Column P will then make some computations based on the inputs from col F to O.
Row 55 will also make some computation based on inputs from row 10 to 54.

How to I modify the code below to allow users to either add/delete columns and rows such that it does not fowl up the computations?

The computation does not have to be at column P or at row 55, they can be dynamic and change depending on how many rows and columns the users delete/add.

A little background on what the code does. From Column F to O, the code UNLOCKS the columns only if user inputs date in Cell 3 of that particular column.

Example. Column F is locked from F10 to infinity at the start. Only when user inputs date into F3 does the cells F10:F54 is unlocked for user to input data.

This goes on until column O. I want users to be able to add more columns, or delete ones they don't need.

View 2 Replies View Related

Hiding Chart Sheets If Users Disables Macros

May 10, 2008

I am using Reafidy nice bit of code to hide worksheets if the user disables macros. The problem, though, is that it doesn't work for Chart Worksheets. How should I adjust this to accommodate charts?

Private Sub Workbook_BeforeClose(Cancel As Boolean)
bIsClosing = True
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim wsArray() As Variant
Dim iCnt As Integer
Application. ScreenUpdating = 0

Splash.Visible = True

View 4 Replies View Related

How To Password Protected All Sheets At Once

May 15, 2014

i want to protect my all sheets at once

View 3 Replies View Related

Macros On Protected Sheets

Nov 21, 2006

I have a spreadsheet with some macros in it. When I run the macros, I would like to unprotect the worksheet and then protect the spreadsheets when the macros are done. The excel tabs I would like to protect/unprotect are called Graph and Data.

View 3 Replies View Related

How To Unprotect A Workbook And Sheets That Already Protected

Mar 10, 2014

I have a workbook that is protected by password. I have to unprotect sheets.

How can I unprotect sheets and workbooks while I am updating or changing?

View 13 Replies View Related

Search Column A In All Protected Sheets

Nov 15, 2008

I need a simple Macro that will, sheet by sheet, search the entire workbook. However, it only needs to search Column A, and there need be no text box, because the user will not define the text. The search text will simply be "X"

The real issue that I'm having is that I need it to find the first item, then offer me the option of selecting "Next" "Previous" or "Cancel" "Cancel" of course would mean that the item found is the one being searched for.

View 14 Replies View Related

Custom View When Other Sheets Protected,

Nov 29, 2007

I have a workbook with 3 spreadsheets. When I put ptotection on 2 of the sheets, the custom view will not work on the other. Any way to make the views work?

View 5 Replies View Related

Comboboxes, Autofilter And Protected Sheets

Jun 12, 2006

Everything works fine except when I password protect the sheet. Then when the autofilter is used an error message is triggered and the error relates to the first range selected in the combobox code. However, the combobox itself works fine on the protected sheet as I included code to unprotect the sheet at the beginning of the code run by the combobox and reprotect it at the end.
Any advice suggestions gratefully received.

View 9 Replies View Related

Running Macros On Protected Sheets ....

Feb 19, 2007

I have the following code as workbook module but it is not working, I have tried fiddling with it but I cannot work out what is wrong, can anyone help please.

Private Sub Workbook_Open()

Dim ws As Worksheet ....

View 9 Replies View Related

Getting Error When Userform Transfers To Protected Sheets

Jan 30, 2014

I have a userforms which transfers data to protected sheets.The userforms worked until i protected each sheet.Can there be any code which i add to the current userform code so it can still transfer the data to protected sheets

The other issue also is now that the sheets are protected the Outlining also does not work.Can this also be changed so the Outlining works on protected sheets

I have 5 userforms which all transfer data.

[Code].....

View 5 Replies View Related

Find & Replace On Protected Sheets Fails

Jan 10, 2007

I am attempting to run a macro that will do a find and replace on a protected sheet but this is not working. I am using the following code to Protect all Sheets, which I found on this site when workbook opens using the Workbook Open Event and uses UserInterFaceOnly :

Private Sub Workbook_Open()
Dim wSheet As Worksheet

For Each wSheet In Worksheets
wSheet.Protect Password:="111", _
UserInterFaceOnly:=True
Next wSheet
End Sub

And then a find and replace similar to this:

Sub FindAndReplace()
Selection.Replace What:="w", Replacement:="a", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

View 6 Replies View Related

Sort Data On Protected & Hidden Sheets

Sep 16, 2007

Is there a way I can sort multiple hidden protected worksheets with a password “Protect”
I have 12 worksheets “Jan”, “Feb”. Etc

“The Range on each worksheet is the same ("A11:CR200") ....

View 9 Replies View Related

Retain Use Of Group/Outline On Protected Sheets/Worksheets

Oct 5, 2006

I have a sheet that I protect but i use the below code so that I can still use my gouping '+' or '-' symbols to hide/unhide rows.

ws.Protect Password:="PASSWORD", userinterfaceonly:=True
ws.EnableOutlining = True

This is ok but When close the workbook and reopen it, my sheet becomes fully protected and i cant use the group icons. Can anyone either suggest better code or a way to initilise the workbook to act in this way when it loads up. For Reference Below is my full

Sub ProtectAll()
Dim ws As Worksheet
sSheet = Control.Name
For Each ws In ThisWorkbook.Worksheets
Select Case ws.Name
Case sSheet1
Case Else
ws.Protect Password:="PASSWORD", userinterfaceonly:=True
ws.EnableOutlining = True
End Select
Next ws
End Sub

View 2 Replies View Related

Protected Sheets With Macros Giving Runtime Error 1004

Mar 3, 2009

I created several macros objects to do simple hide columns, filter on, filter off, etc. type functions, using the Tools / Record Macro feature. Then discovered they won't work in a protected worksheet. Is there a way around this situation, other than turning protection off? Here's an example of the code for one of them, although I get the error or every attempt to perform a macro once the sheet is protected:

View 4 Replies View Related

Change VBA To Password Protect All Sheets To Allow User To Select Protected

Apr 8, 2009

I need to change VBA to Password Protect all sheets to allow user to select protected. I have:

View 2 Replies View Related

Custom Zoom Set At 90

Dec 23, 2008

If I send a workbook out with the zoom set at 90...will the zoom be at 90 when others open it.? Also, is there a worksheet event that I could insert to force a specific worksheet to always open with the zoom at 90??

View 2 Replies View Related







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