Copy

Newsletter by jkp-ads.com

View this email in your browser

jkp-ads.com Newsletter for March 2016

The Amsterdam Excel Summit

Registrations for our famous Amsterdam Excel Summit are pooring in. Make sure you reserve your seat soon as we only have limited space available! Join us on May 26th and 27th, 2016 in Amsterdam for the third Amsterdam Excel Summit. This time the Summit itself is a one-day event but we have added a post-conference training day: The Excel Charting And Dashboard Masterclass.

Redmond is there

Note that we'll have people from the Excel dev team at the conference, we will host a keynote from the people building Excel and you can ask them any question you like!

Register now!!!.

Prevent deleting of sheets without protecting the workbook

In one of the many forums I frequent I ran into this question:
"I'd like to prevent people from deleting sheets from my workbook, but I do not want to protect the workbook, how can I achieve that?". Here is my solution:

Open the VBA editor and double-click the ThisWorkbook module in the project explorer. Select Workbook from the dropdown on the left, just at the top of the code window. Select "SheetDeactivate" from the right-hand dropdown. You should get:

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
End Sub

Now add two lines of code so it looks like this:

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    ThisWorkbook.Protect , True
    Application.OnTime Now, "ThisWorkbook.RemoveProtection"
End Sub

And add this routine:

Sub RemoveProtection()
    ThisWorkbook.Unprotect
End Sub

So what happens here? As soon as you try to delete a worksheet, but just BEFORE the sheet is really removed, the SheetDeactivate event fires. In that event I protect the workbook structure. But I also schedule a macro to run after the event is finished so the protection is immediately removed.
If a user now tries to delete a worksheet, he gets this message: "Workbook is protected and cannot be changed."

Dates for Excel VBA voor Financials (7th run)

The dates for the seventh run of our successful (Dutch) course "Excel VBA voor Financials", which I present together with Tony De Jonker are: June 1, 8 and 15, 2016 For more information, visit topexcelcursus.nl

Financial modelling with Excel

Together with Tony de Jonker I hosted this very succesful in-house training on February 2, 2016.

Advanced Excel VBA

This in-house training covering advanced VBA subjects such as Error handling, Userform design, Class modules and etcetera has been a great success. We're currently looking what the best dates are to teach this class for the second time.

Auditing of Formulas made easy

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.
 

Mission-critical Excel Model Crashes

Do you have mission-critical Excel files that cause problems? Consider our Excel File Remediation Utility
.
 

Nederlandse cursus: Excel VBA voor Financials

Kost uw maandrapportage u vele uren saai en repeterend werk? Dan is het de hoogste tijd voor onze cursus Excel VBA voor Financials!.
De Volgende cursus wordt gegeven op 1, 8 en 15 juni 2016
 
Copyright © 2016 JKP Application Development Services, All rights reserved.


unsubscribe from this list    update subscription preferences 

Email Marketing Powered by Mailchimp