Using macros on a protected workbook

[deanblew]

Hi all,

I have multiple macros on a workbook which I need to protect how do I enable the use of the macros whilst protected?

D

[mjr veverka]

In 'ThisWorkbook' module:
(enabling the execution of macros on a secured workbook)

Please Login or Register  to view this content.

In module 'Module1' (at the top of module)
(hiding the macro preview)

Please Login or Register  to view this content.

In editor vba (alt+f11), see image.
(to protect macros from unauthorized browsing)

[deanblew]

I'm not sure what I need to do here....?

[mjr veverka]

1. open your workbook
2. press alt+f11
3. in the vba editor, in the left panel (Project - VBAProject) select the module "ThisWorkbook"
4. paste the "Workbook_Open" procedure code here (with your own password)

Optionally, in the 'Module1' module enter the 'Option Private Module' clause, to hide macros from prying eyes, as well as you can protect the vba editor using a password.

[deanblew]

Thanks got your help, works fine

[deanblew]

Hi again,

I thought this worked but it didnt, im really not getting it, this is my code what do i paste in and where?


Sub reset()
'
' reset Macro
'

'
Cells.Select
Selection.EntireRow.Hidden = False
Range("D6").Select
End Sub
Sub search()
'
' search Macro
'

'
Cells.Select
Selection.EntireRow.Hidden = False
Range("D6").Select
Calculate
End Sub

[mjr veverka]

And what exactly do you want to do (because you mark minimum millions of cells, and then you're trying to unhide minimum tens of thousands of rows) ?

Please Login or Register  to view this content.

Old excels = 16,777,216 cells = 65,536 rows x 256 columns
New excels = 17,179,869,184 cells = 1,048,576 rows x 16,384 columns

[deanblew]

Sorry for the late reply, thanks for yopu help - I saw my mistakes and took your advice in the size of the actions.