emaar

[emaar]

Hi I want to write a vba code doing the following:
My workbook is protected with a password. However when I update my workbook with a data web import it must be unprotected. After finishing the import and having updated the workbook, I want my vba proceedure to protect the workbook again with the same password. Does anyone have a routine for this?

Einar

 

[cstimart]

Hi I want to write a vba code doing the following:
My workbook is protected with a password. However when I update my workbook with a data web import it must be unprotected. After finishing the import and having updated the workbook, I want my vba proceedure to protect the workbook again with the same password. Does anyone have a routine for this?

Einar

You should be able to do that using "Record Macro".

 

[p45cal]

You might get away with using the UserInterfaceOnly aspect of protecting a sheet (just rtealised you said the workbook was protected but…). Check it out, it only needs to be executed once, and remains in force until the workbook is closed again. It allows code to change the sheet, but not people.

 

[emaar]

You should be able to do that using "Record Macro".

Thanks I have tried that, but it doe not record the passwords, only the commands...

 

[emaar]

You might get away with using the UserInterfaceOnly aspect of protecting a sheet (just rtealised you said the workbook was protected but…). Check it out, it only needs to be executed once, and remains in force until the workbook is closed again. It allows code to change the sheet, but not people.

Thanks for reply, but I do not know what you mean with UserInterfaceOnly?

 

[p45cal]

I said:"UserInterfaceOnly aspect of protecting a sheet"
In help, under worksheet.protect you have the likes of:
expression.Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)


Check it out.

 

[emaar]

I said:"UserInterfaceOnly aspect of protecting a sheet"
In help, under worksheet.protect you have the likes of:
expression.Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)


Check it out.

OK thanks