Macros Wont Work When I Protect My Worksheet

Sep 14, 2009

I have the follwing macro that is used to hide certain rows: ......

View 11 Replies


ADVERTISEMENT

Password Protect Macros

Dec 4, 2007

I need to protect a macro so that it's code can be viewed only by authorized users.

View 2 Replies View Related

Rewrite Protect Code So That It Will Work With A Hidden Sheet.

Aug 25, 2009

I need this code below to work in a macro on a hidden sheet.. FYI the sheet name is "Closed".

View 2 Replies View Related

Macros To Protect / Unprotect Worksheets And Workbooks

Jul 20, 2005

The first macro protects all sheets in a Spreadsheet and the second unprotects. The the next Macro Protects the enitre workbook and likewise the next one Unprotects. All using passwords.

VB:
Dim ws As Worksheet
Sub ProtectAll()
Dim S As Object

[Code].....

View 9 Replies View Related

Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?

Jan 12, 2007

I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.

Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub

View 3 Replies View Related

How Does This MACROS Work

Oct 23, 2009

I recently took a macros my friend did and adjusted it so it would work for my problem.

It works fine but there is one thing i don't understand about it.

The initial problem was that i needed a macros that could copy a range and paste it 1 cell space to the left and then delete the last cell of that range, so it would look something like this:

FROM THIS:

HIJKLM2NIVEL
3
21
TO THIS:

HIJKLM2NIVEL3
21

so this is the macros i am using which works perfectly:

Range("H1").Select
Selection.End(xlDown).Select
Selection.Offset(0, 2).Select
RC = Cells(Columns.Count, ActiveCell.Row).End(xlUp).Column
Range(ActiveCell, Cells(RC, ActiveCell.Row + 11)).Select
Selection.Copy
ActiveCell.Offset(0, -1).Select
ActiveSheet.Paste
ActiveCell.Offset(0, 4).Select
Selection.ClearContents

What i don't understand is why i have to use the +11 in order for it to move 4 spaces to the right.

View 9 Replies View Related

Encourage Enabling Of Macros: Disable Macros When Opening Then The Worksheet Menu Bar And Other Command Bars Are Still Available

Aug 26, 2009

I have an Excel 2003 program that contains macros. One of the macros hides certain command bars and disables the worksheet menu bar. On close the opposite is true. The problem is, if a user uses the disable macros when opening then the worksheet menu bar and other command bars are still available. I would like to hide all of the data sheets and display another sheet that would normally be hidden displaying a message that the macros have to be enabled for the program to work correctly if disable macros is chosen. When the enable macros are used I would like the Error page to be hidden.

View 6 Replies View Related

Macros To Work In Certain Cells

May 22, 2014

Is it possible to only allow a macro to work in certain cell?

View 1 Replies View Related

Macros That Only Work On One Sheet?

Apr 2, 2009

If i have a macro, is it possible to have that macro work on a specific sheet and not the whole work book.

I.e I have two sheets one where you can insert a line and other where you cant insert a line, at the moment i can insert in both sheets.

View 3 Replies View Related

Macros Won't Work With Decimals

May 8, 2009

I've been trying to create an excel macro to calculate shortest route path using floyd algorithm..

Problem is, i can't figure out why this macro won't work with decimal numbers..
I'm pretty sure there's a VERY simple explanation for this..
Probably has something to do with excel's formating

See the attachment and press Run button, it won't produce the correct result, but if if you multiply all the numbers in "input" sheet by 100.

View 14 Replies View Related

Locking Macros In Spreadsheets At Work

Jun 27, 2014

I need to lock the macros in spreadsheets at work.

If I go to Developer>Macros I can edit any of the macros.

So to protect them I went to Visual Basic>Tools>VBA Project

What I don't understand is that there is already a password there.

How it is possible that I can edit any of the macros under Developer>Macros when there is a password which I haven't entered under Visual Basic>Tools>VBA Project

View 8 Replies View Related

Macros Dont Work Even On Low Security

Aug 21, 2009

My dad wrote me a VB programme to save me time entering repetitive data into an excel template for my business. At first it didnt work untilll i reduced security to low. Sice then I fried my computer and have had to reformat it with a diffirent version of windows, vista service pack 3. Now even on low security it doesnt work.

The little button in the worksheet to make the macro happen isnt visible or doesnt exist.

View 13 Replies View Related

A Few Macros Dont Work Properly With Personal.xls

Jun 18, 2008

I wondered if I could pick your brains and hopefully get some answers to my problem. I have recently been using the Personal.xls worksheet to make all my Macros available to all open workbooks so that I don't have to cut and paste Macros each time I wanted to use them.

Now I know you sometimes have to make certain adjustments to Macros in order to make them work globally. I wondered if I could find out how to amend the codes below to make them work properly. Thanks.

The first code Macro below deletes all worksheets in a workbook except for the currently active sheet. However it no longer works.

View 14 Replies View Related

What Changes Are Required For XL2003 Macros To Work With XL2007 Wbks

Dec 11, 2009

1. I've written a few macros using MSExcel 2003 VBA that I've tested successfully on Office 2007, but with 2003 workbooks only. Since the filename extensions for Excel 2007 workbooks are different from those for 2003, what changes are required in my vba code to ensure that it will work with 2007 workbooks too?

2. Will changes to vba code be necessary even for changes in the operating system (e.g. Vista / Windows 7)? I have worked with my vba codes on Win XP only.

View 9 Replies View Related

Excel 2007 :: Creating Workbooks With Macros That Work On Other PCs

Apr 20, 2012

I have written a 2007 workbook which contains 4 simple macros. One of the macros automates the process of saving the print range as a .pdf file. It works fine on my pc but when I send it to others to use, when they try the macros, they all return a 1004 runtime error.

View 6 Replies View Related

Excel 2010 :: Macros No Longer Work When Workbook Shared

Aug 22, 2012

Using Excel 2010.

I've created a spreadsheet at work that has two summary tabs which contain hyperlinks to around 30 separate sheet tabs.

On each sheet tab there is a list of unique values in column A (and other information relating to each value in columns B to D which are repeated for more than one unique value). In column E, users enter a test script name against each unique value they wish to 'reserve', and the macro picks out the unique test script names and via the COUNTIF formula counts the frequency of each test script name for each of the different values in column B.

My problem is that the macro seems to work fine if the workbook is not shared, but errors if the workbook is saved as shared. The error is 'Run time error 1004 - Unable to select the MergeCells property of the Range class'.

Here is the macro code:

Sub Get_Policies_Per_Script(updCol As Long, ShtName As String)
Dim rowctr As Long
Dim tgtrow As Long

Const ppsformula As String = "=COUNTIFS($A$3:$A$65000,I$24,$E$3:$E$65000,$G"

If updCol = 5 Then 'test name column has been modified

[Code] ..........

View 9 Replies View Related

If Macro Is Disabled: Place A Message On The Sheet Saying This Will Only Work With Macros Enabled

Aug 17, 2006

When you enable macros the sheets 2, 3, 4 ect are visible but if you disable macros, you only see sheet 1 and and you can place a message on the sheet saying this will only work with macros enabled.

View 2 Replies View Related

Creating Macros To Transfer Data From Worksheet To Worksheet?

Mar 26, 2014

transferring data from a worksheet (Passdown Report) to another worksheet (Data Base) located in the same workbook. In the source worksheet (Passdown Report) there are 2 cells (B2 and D2) in which I would like the data to be transferred along with the data from B4 to AQ33. All the cells contain a formula which I want to stay after the information is transferred to the target worksheet (Data Base). This will be a daily transfer to the target worksheet (Data Base), so the macros should also identify the next available open row to transfer the data to.

View 1 Replies View Related

Protect A Worksheet From Changes

Apr 24, 2009

how to protect a worksheet from changes so that I am still able to change one cell on the worksheet but not any other cells.

View 2 Replies View Related

Protect Worksheet Upon Closing?

Jul 11, 2013

How can I get my workbook to automatically re-protect a single worksheet in a workbook at the save-then-close point? It doesn't need to be password protected.

View 5 Replies View Related

Protect Worksheet Before Emailing

Mar 30, 2009

I found this link in numerous places on this forum to email just a single worksheet from a workbook using one macro.

HTML Code: ....

View 12 Replies View Related

Protect Worksheet With Password

Jan 21, 2010

the user is prompted with a password inputbox to both protect and unprotect my worksheet named: Data. I am using Excel 2003.

View 3 Replies View Related

Protect The Worksheet With Password

Jun 7, 2008

I had the thought that maybe it would be possible to have a worksheet that is not protected when saved but when it is opened there would be a sub-routine under Sub_Workbook Open that would step through each sheet and assign a random password. And when the workbook is saved it is saved without passwords again.

In this way there would be nothing for a password cracker to pick at. The only flaw I see would be that the password to open the VBA module would need to be static and this would open up the programming to change and remove. But wouldn't this be effective against most users who would only know about the utilities to open the passwords and not the programming behind excel.

View 9 Replies View Related

Protect A Hidden Worksheet

Jun 10, 2005

Is it possible to protect a hidden worksheet. I do not want them to be able to unhide the sheet unless they know a password to do so.

View 9 Replies View Related

Protect Worksheet But Allow Some Features

Sep 5, 2007

I am trying to use protection in order to prevent users from only inserting a row or a column, sort, and autofilter. I don't think Userform is a good choice for this situation. I've tried using the following

Sub MyMacro()
ActiveSheet. Unprotect
'YOUR CODE
ActiveSheet.Protect
End Sub

The problem I'm running into is, when I protect the sheet from the main screen (allowing for everything but those listed above), then run MyMacro, the things that were previously allowed under protection are no longer allowed. Indeed, upon re-protection it prevents the user from accessing anything other then the very basics (selecting cells). How can I make it so that the protection works the same as before the macro?

View 4 Replies View Related

Protect Worksheet On Paste

Jan 14, 2008

I want to copy a protected cell from one file to another, and still preserve the protected properties. Currently, the copied cell will be unprotected.

I have a lead that I might need to override ctrl-c function to my own VB script.

How do we override ctrl-c function? What lines to put in VB file?

View 9 Replies View Related

Password Protect To Open Worksheet

Jul 22, 2008

I know of the password protect feature to open a excel file or workbook, but does anyone know if this can be done for opening a worksheet.

I want to be able to view a worksheet after a password is entered, so therefore different worksheets have different passwords.

View 9 Replies View Related

Protect Worksheet And Data Validation

Oct 27, 2009

I have my spreadsheet protected and all the neccessary fields locked/unlocked, but one of the columns contains data validation. How can I prevent a user from copying and pasting a value into the data validation cell versus of course the intended purpose of picking from the list?

View 9 Replies View Related

Protect / Unprotect Worksheet Before VBA Runs

Oct 26, 2011

I have a file that needs to be locked down so that the end user does not have the ability to enter data where they shouldn't. The end users are very Excel illiterate, and have proven that I need to have high security in place. Here is my current VBA code - the purpose of which is to hide/unhide rows depending on data entries. (Disclaimer: this code may not be pretty as I am a VBA rookie, and I've begged borrowed and stolen from about 10 other threads on this board to get where I am, and yes it works).

Code:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "C7" Then Call Changeto1
If Not Intersect(Range("c9"), Target) Is Nothing Then
Rows("15:44").EntireRow.Hidden = True
Rows("15:" & Range("c9").Value + 14).EntireRow.Hidden = False
End If

[Code]...

The question is now....how can I unprotect the sheet so that this code works without allowing them to enter data where they shouldn't. I've been at this for days already.

View 7 Replies View Related

Protect Worksheet And Data Validation

Oct 28, 2009

I have my spreadsheet protected and all the neccessary fields locked/unlocked, but one of the columns contains data validation. How can I prevent a user from copying and pasting a value into the data validation cell versus of course the intended purpose of picking from the list?

View 9 Replies View Related







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