| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to record a macro that would lock a sheet
hi again
is there a way to have macro lock a specific sheet for editing when the macro is run, then maybe have it password protected for editing afterwards thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is it possible to record a macro that would lock a sheet
When a macro runs the sheet is already effectively locked. You can protect
it afterwards with worksheets("Sheet1").Protect -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "des-sa" wrote in message ... hi again is there a way to have macro lock a specific sheet for editing when the macro is run, then maybe have it password protected for editing afterwards thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is it possible to record a macro that would lock a sheet
Hi Bob,
Following on from that, how would you code it to protect all sheets in the workbook? Cheers -- Deirdre "Bob Phillips" wrote: When a macro runs the sheet is already effectively locked. You can protect it afterwards with worksheets("Sheet1").Protect -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "des-sa" wrote in message ... hi again is there a way to have macro lock a specific sheet for editing when the macro is run, then maybe have it password protected for editing afterwards thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is it possible to record a macro that would lock a sheet
Just loop them all
For Each sh In Activeworkbook.Worksheets sh.Protect Next sh -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Diddy" wrote in message ... Hi Bob, Following on from that, how would you code it to protect all sheets in the workbook? Cheers -- Deirdre "Bob Phillips" wrote: When a macro runs the sheet is already effectively locked. You can protect it afterwards with worksheets("Sheet1").Protect -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "des-sa" wrote in message ... hi again is there a way to have macro lock a specific sheet for editing when the macro is run, then maybe have it password protected for editing afterwards thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is it possible to record a macro that would lock a sheet
Thank you Bob :-)
-- Deirdre "Bob Phillips" wrote: Just loop them all For Each sh In Activeworkbook.Worksheets sh.Protect Next sh -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Diddy" wrote in message ... Hi Bob, Following on from that, how would you code it to protect all sheets in the workbook? Cheers -- Deirdre "Bob Phillips" wrote: When a macro runs the sheet is already effectively locked. You can protect it afterwards with worksheets("Sheet1").Protect -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "des-sa" wrote in message ... hi again is there a way to have macro lock a specific sheet for editing when the macro is run, then maybe have it password protected for editing afterwards thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is it possible to record a macro that would lock a sheet
This was a very helpful post. I was wondering if it's possible to create a
macro that would protect all the worksheets in the workbook but also allow users to edit a certain range? Thanks, EugeniaP. "Diddy" wrote: Thank you Bob :-) -- Deirdre "Bob Phillips" wrote: Just loop them all For Each sh In Activeworkbook.Worksheets sh.Protect Next sh -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Diddy" wrote in message ... Hi Bob, Following on from that, how would you code it to protect all sheets in the workbook? Cheers -- Deirdre "Bob Phillips" wrote: When a macro runs the sheet is already effectively locked. You can protect it afterwards with worksheets("Sheet1").Protect -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "des-sa" wrote in message ... hi again is there a way to have macro lock a specific sheet for editing when the macro is run, then maybe have it password protected for editing afterwards thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| Record New Macro | Setting up and Configuration of Excel | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| how do i create a record sheet | New Users to Excel | |||
| Service record sheet | Excel Discussion (Misc queries) | |||
![des-sa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
