Woo-hoo! Here I go again, maybe I'll get it right this time, who knows. Okay, sorry about the last post (I violated Rule 11, not very awesome for my first geaux), let me take it out of the VBA forums and post here in General. Here is my dilemma:
I am in the military. My commander wants two Excel spreadsheets pulled at his leisure and pronto on a normal basis, usually 2-3 times a day. I have been able to do this in 2-4 minutes for the past year. But, oh yeah, a huge BUT--we recently upgraded to Excel 2010 with no option to downgrade to 2007 and now it takes me half an hour to ready these spreadsheets. Now Excel 2010 saves the same files I have always pulled and locks them. Ridiculous! It did not do this with 2007. I have two spreadsheets (officer and enlisted) with nine tabs each. Now instead of highlighting, marking bold and underlining the top line and saving my work, I now have to cut and past all nine tabs, for each spreadsheet, into new spreadsheets and then mark it all for him. There is no security concern here. I wish not to bypass any security issue, I simply want to copy text, that is copyable, in one go. Not 18 different times. Is this possible?
Also, is it possible to run a macro that highlights the top line, marks it bold then underlines it for all nine worksheets in a workbook? If so, where do I start? I am willing to self-teach, I have no problem learning on my own, but I need a little nudge in the right direction.
And finally, I also have a third workbook I pull with twelve tabs, it too locks and it is pulled from another system... so the problem is with Excel. Again, I wish not to violate any security programs or hack anything. I simply want to copy text that, as far as security is concerned, is legal to copy. Please help!
_____________
I did some testing and messing around, and my problem is Protected View. I've used all types of trust center edits and whatnot and have determined the culprit is in the File Block Settings. Being on a government computer I have absolutely no way of turning off the Excel95 Workbooks file block. With that said, am I basically screwed? It's a dang shame I can't get 2007 back... so frustrating.
Bookmarks