Is it Application.ScreenUpdating or Something Else ?

[Farah]

Hello,

I have a code, which send keys for Alt+F11, while it is doing so, it shows the Alt+F11 Screen. I do not want it to be shown, what exactly can i do to keep it on the Excel sheet and take the actions.

Regards,
Farah

 

[Norie]

TazGuy

I'm pretty sure the OP has already been to that link.

In fact I might have supplied it previously.

But after being given that link the OP came back with the problem of a protected VBA project.

There is nothing on Chip's site that deals with that, but I think somebody else suggested the SendKeys method to unprotect the VBA project.

I'm still waiting for an answer as to why the OP needs to delete the code.

 

[Farah]

quote:
--------------------------------------------------------------------------------
In Excel 2002, you must have "Trust Access To Visual Basic Project" enabled. To enable this setting, go to the Tools menu in Excel, choose Macros, Security, then the "Trusted Sources" tab, and put a check next to "Trust Access To Visual Basic Project". Otherwise, you will get errors.
--------------------------------------------------------------------------------

Thank for your replies:

Norie, deleting VB has a purpose, this is the project requirement to do so, & the project while being operated by users must also be protected. But users are authorized to "click a button" which will do certain actions along with deleting VB's for another purpose, which is a must for the project.

Wish i could explain it any better.

Taz, you are right, i was going to post another question for the sendkeys to check"Trust Access to Visual Basic Project". Do you think it is a good idea to do this ? I mean, All things work perfectly, the way i want it, but for users, if "Trust Access to Visual Baisic Project" is not checked, it gives error.

Can i please have the "Sendkeys" to check "Trust Access to Visual Basic PRoject" or this is not a very good idea ?

Anyway, I have tried this, think something is not correct.

Sub Rectangle1_Click()

Application.SendKeys "%T"
Application.SendKeys "E"
Application.SendKeys "S", True
Application.SendKeys "^{PGDN}"
Application.SendKeys "{TAB}"
Application.SendKeys "{TAB}"
Application.SendKeys "{SPC}"

End Sub

Warm Regards,
Farah

P.S. I also look forward for some help on the main question.

 

[Norie]

deleting VB's for another purpose, which is a must for the project.

Why is it a must?

 

[Farah]

Hello Norie,

The button on which this code is placed says "Issue Report", which is used to issue a Report to the Client.

This button does certain actions (delete unwanted sheets, which are not part of the "Reporting sheets" & does the filtering parts etc. plus some other actions like deleting all buttons etc. from the "Reporting sheets", but still the Client can use Tools | Macro or Alt+F11 or maybe Alt|Shift+F11 etc. to access VB to see the codes (I know they can easily crack it ) & i do not want the Client's copy to have any code to see what criteria we have set for discounts and pricing etc. Don't want to take any risk on sending them a copy having the codes.

Thank you once again...

Warm Regards,
Farah

 

[Farah]

I am not 100% certain, but I think the send keys will cause automatically turn screenupdating back on.

Is there a way that while code is running, it remains on the Excel Screen as per the code i posted ?

Thank you.
Farah

 

[tusharm]

You need to develop software in which the data are separate from the code. Create an add-in. Start with http://www.mrexcel.com/board2/viewtopic.php?p=148963#148963

{snip} & i do not want the Client's copy to have any code to see what criteria we have set for discounts and pricing etc. Don't want to take any risk on sending them a copy having the codes.

Thank you once again...

Warm Regards,
Farah

 

[Norie]

Farah

As Tusharm has suggested, and I think i have too in previous posts, you need to seperate the data from the code.

Either try Tusharm's add-in suggestion or consider just copying the data, and only the data, to a new workbook.