Combo, I tried what you suggested with the VBE and it will still open the workbook and stop running.
Skip, The shift key was removed from the macro shortcut but now I am running into problems of users needing to bold or copy information and macros running instead of ctrl-c copying etc.
We did...
Yes. When it is stepped it works.
I changed the macro keyboard shortcuts to have no shift and the code runs as expected.
It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the...
The main workbook holds all the code and runs it, the other workbook simply is a log of data entry errors. So as the macro in the main workbook runs, it opens the log but when the log is opened the code simply stops. There are no error warnings, no pop ups, nothing.
I found out from various web...
Greetings one and all,
This one has been bothering me for awhile and Microsoft hasn't been any help.
I have code to open a workbook, however due to the known bug in Excel sometimes the code simply stops when the workbook is opened. Microsofts patch (below) deals with the shift key and isn't...
Thanks Skip!
It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug...
This is a new one for me and something that was just discovered with our main workbook.
Worksheets will sometimes get copied over to the main workbook. However this can create names in the name manager and recording a macro didn't offer any light on how to remove all the names. Since I don't...
Thanks to both of you.
Skip that gave me what I needed.
It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning...
I am trying to set up a page so that when it is printed the print area is preset.
So far I have found ways to print the selection and toyed with Workbook_BeforePrint, but have not found a way to preset the selection area for the user. Given the amount of printing, setting the print area is...
I am not following what you want to do.
Are you trying to underline or bold text or are you trying to copy it somewhere?
And yes, text can be converted to HTML, just don't remember how at the moment.
It has taken me a while to make sense of what I hear at work involving computers. There is...
Found this link
http://stackoverflow.com/questions/18601744/excel-headers-footers-wont-change-via-vba-unless-blank
Haven't yet been able to test and see if that solves the problem.
It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and...
You are correct.
The footer is created for each sheet because it holds specific information for that sheet.
CB_PANEL_NAME references which two sheets the footer is identifying
JOB_NUMBER is the number the shop and engineers use
TEMP_NMBR holds the specific info for the job number and...
I don't know the problem has been solved long term, however I was able to get the pages to print with the footers showing properly. If possible, I would like to find or write code that will stop this from happening again.
It has taken me a while to make sense of what I hear at work involving...
Thanks Combo. That didn't solve the problem directly but it made a huge leap forward.
I ended up having to recreate my sheets with the correct footers and then printing them without going into print preview.
It has taken me a while to make sense of what I hear at work involving computers...
The other forum post was aimed at possible worksheet issues targeting printing, this post was aimed at more behind the scenes things that would be more coding oriented.
It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.