Thanks for the reply and directing me the blog. Both were great Regards subu
On May 25, 9:49 am, ddadmin2009 <ddadmin2...@gmail.com> wrote: > 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 > detailshttp://funwithexcel.blogspot.com/2009/05/macro-basics-assigning-macro... > > 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://ma...> > > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
