Hi Subu, To make your work easy assign the macro you have recorded to a shortcut key or a button. Check the article below to get familiar with those details http://funwithexcel.blogspot.com/2009/05/macro-basics-assigning-macros-to.html
Just in case if you are not at all familiar with VB Editor and very new to macros follow the below first steps: 1. With the workbook active, open the VB Editor (Alt+F11). 2. You should see a tree view with a node that says something like "VBAProject (Book1)". 3. Find the ThisWorkbook node below it and double-click it. A code editor will appear. 4. Paste the Code Block there and Save the workbook. 5. Now come back to excel sheet and to run the macro use the shortcut Alt + F8. Select the macro you want to run and click Run. Hope this helps. On Fri, May 22, 2009 at 10:36 PM, Subu S <mail_to_s...@yahoo.com> wrote: > Dear Members > > I'm new here. I'm amazed at the friendliness and Samaritan approach in this > group. This place is excellent...... > > I'm a novice and please bear with me... > > Question > --------------------- > Let us say I wish to use the macro below. What should I do ? where should I > paste it on the XL sheet ? what commands should I use to make the macro run > > Other stats about me : > --------------------------------- > Win XP SP 3 user > XL 2003 user > I've recorded macros using "Record macro" facilities but never copied > macros and used them > I have _no_ VBA knowledge > > Thanks in advance > best regards > subu > > > > ============================================================================== > TOPIC: Protect and unprotect all sheets > http://groups.google.com/group/excel-macros/t/cf696d1ba47ebfa8?hl=en > > ============================================================================== > > > == 2 of 3 == > Date: Thurs, May 21 2009 9:32 am > From: Paul Schreiner > > > WITH password or WITHOUT? > > Depending on what options you want on the "protect", you can use: > '------------------------------------------------------------------- > Option Explicit > Sub Protect_all() > Dim pw_ent, sht > pw_ent = "test" > For Each sht In ThisWorkbook.Sheets > ThisWorkbook.Sheets(sht.Name).Protect _ > DrawingObjects:=True, _ > Contents:=True, _ > Scenarios:=True, _ > AllowFormattingCells:=True, _ > AllowFormattingColumns:=True, _ > AllowFormattingRows:=True, _ > AllowInsertingColumns:=True, _ > AllowInsertingRows:=True, _ > AllowDeletingColumns:=True, _ > AllowDeletingRows:=True, _ > AllowSorting:=True, _ > AllowFiltering:=True, _ > AllowUsingPivotTables:=True, _ > Password:=pw_ent > Next sht > End Sub > Sub Unprotect_all() > Dim sht, pw_ent > pw_ent = "test" > For Each sht In ThisWorkbook.Sheets > ThisWorkbook.Sheets(sht.Name).Unprotect Password:=pw_ent > Next sht > End Sub > '------------------------------------------------------------------- > You should record a macro in which you protect a sheet with the appropriate > permissions in order to know what options to use. > > hope this helps, > Paul > > > > > ------------------------------ > Get your new Email address! > <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/aa/> > Grab the Email name you've always wanted before someone else does! > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
