my comment pop-up rectangular boxes regularly collapse to almost one dimensional [ie] a rectangle with maybe 1/32 inch width and undiminished original length?
thus no comment box text is visible.
ANY advise, etc. will be much appreciated.
my comment pop-up rectangular boxes regularly collapse to almost one dimensional [ie] a rectangle with maybe 1/32 inch width and undiminished original length?
thus no comment box text is visible.
ANY advise, etc. will be much appreciated.
using VBA, cause you would need to trigger it?
one to make small one to make bigPlease Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
many thanks humdingaling.
however I don't understand the VBA concept and don't have the time to self-educate.
if, with directions, it is easy to implement, please link me to those directions. otherwise I will
contract it out because I really need my comment boxes.
http://answers.microsoft.com/en-us/o...6-b7b6fd8db781
people at this link say the problem has been with excel forever, yet it has gone unfixed by Microsoft
essentially i think you only want the enlarge one by the sounds of things
http://office.microsoft.com/en-au/ex...102174076.aspx
here is how it move macro onto your personal computer
alternatively i have attached workbook with macro in it already
the only other thing would be to know how to run macros
http://www.dummies.com/how-to/conten...010-macro.html
many many thanks ... again. really helpful. I am busy with other tasks but will surely get to it soon.
not a problem
i will remain subscribed for some time so if you have issues with it just reply to thread
Cheers
Hum
--------------------------------------------------
I’m having trouble implementing this. [I have excel 2013] [e.g.] google search help
documents describe how to show the excel developer tab
[they say for excel 2010 & 2013] but what I see doesn’t match what they say.
I want to be as certain as possible that I am stumbling along on the right path so......
will the easiest way to start implementing the macro be the following;
download the attached workbook with the macro already in it.
follow the directions in the http://office.microsoft.com/en-au/ex...102174076.aspx link you provided
[ie] ‘’Copy your macros to a Personal Macro Workbook’’
hi again humdingaling in Sydney.
on second thought I think I will have a contract programmer do this for me.
do you do that or can you refer me to someone who does?
thanks again. your detailed help has been superb.
sorry your profile said excel 2007 so i gave you link for 2007
Ron De Bruin gives examples for all excel versions
http://www.rondebruin.nl/win/personal.htm
Don't think this macro is complex enough to warrant contract programmer
maybe youtube can help you with step by step
https://www.youtube.com/watch?v=8Lj3NaWLzOY
Re: contract programmer
no idea, I'm here in Australia
ps have a quick view of the youtube clip
i think you will be able to follow it relatively easily - its 2013 so things will look familiar
the macro and the video that you sent were what I needed. nice job.
after some stumbles I think I have it almost working.
attached is an image for a ‘’run time error 1004’’ and the image which popped
up when I clicked on the ‘’debug’’ button.
please advise … and thanks loads for the help.
I don't think anything got attached in my previous try.
here is another attempt.
still no attachments. they are jpg and I have done it before?
the attachments were...
IMAGE #1
run time error '1004'
Method 'Left' of object '_Application' failed
so then I clicked on the debug button which resulted in
IMAGE#2 which was an image of the
the 5 lines of macro code.
the middle line was hightlited yellow and read
''Application.Left = 595.75''
hmm...my code does not have .left in it?
if the error in some other code?
I just tried to attach files via "go advanced" but I didn't see any indication that they had been attached.
as I remember now, I must go via "go advanced" to attach...is that correct?
I also think I remember being able to tell if the attachment has been successful...is that correct?
I have attached files in the past, gotta be able to do it again.
any suggestions?
I found the following in FAQ but now I can't find the 'Post Reply' button?
How do I attach a file to a post?
To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.
On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.
To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.
Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.
go advanced
manage attachments
+add files
another window should open up
select files
upload files
once completed
window should close
click done
you should see the file under the manage attachments sections
after this click submit reply
after much experimentation I realized there was something wrong with the two images saved by my image capturing
program... with no indication of a problem. very mysterious?
anyhow I resaved the images and now everything works ok.
images are attached [I hope.
hmmmm thats not the code i sent you?
check post #2 for the code
I downloaded the macro from the forum with the same wrong result so clearly
I’m doing something wrong [ie] I don’t understand the excel macro concept
logical design well enough yet.
please tell me what I should do after downloading the macro from this thread…and
please don’t hesitate to quit responding to my posts at any time. I will completely
understand.
although the code is presented in post #2 I have not messed with it, expecting the
code to be contained in the downloaded macro?
An alternative, possibly:
Copy the code from the postPlease Login or Register to view this content.
In Excel, do Alt+F11 to open the VBE
Do Insert > Module, and paste the code in the window that opens
Do Alt+Q to return to Excel
Do Alt+F8 to open the Macros dialog, select JoeM from the list, and press Run.
Entia non sunt multiplicanda sine necessitate
Alt+F11 didn't do anything at first but when I happened to press them simultaneously I got what was probably the VBE.
I didn't see any insert module path nor when I right clicked I saw no insert choice in the drop down panel?
and I do have excel 2013.
I sure wish Microsoft would make all this unnecessary! but it is what it is.
also Alt+Q did nothing?
Last edited by Joe Miller; 09-01-2014 at 03:42 PM.
Insert is on the main menu bar in the VBE.
I think it's working!!!!!!!!!!!!!!!
however, when I try to save it a nasty message pops up saying
''VB project cannot be saved in macro-free workbooks. to save a
file with these features, click no, and then choose a macro-enabled
file type in the file type list''
what should I do now. I am not going to do anything right now because
I don't want to lose what I have so far apparently not screwed up.
Select Excel Macro-Enabled Workbook (*.xlsm) from the dropdown.
it's all working now. many thanks again to both you guys.
still can't believe your patience and time spent with me.
is there a way to have the macro run automatically at start up rather than
doing an explicit Alt+F8, select Macros dialog, select JoeM and press Run?
it is done under a triggered event macro
step by step instructions found here
http://office.microsoft.com/en-au/ex...001034628.aspx
you can do it every time you open any workbook
instructions found under
Creating an Auto_Open macro
or anytime you open a specific workbook
instructions found under
Creating a VBA procedure for the Open event of workbook
sorry if i am giving you too many links but i don't like to copy and paste bulks of other peoples work without acknowledging their work
Last edited by humdingaling; 09-01-2014 at 07:51 PM. Reason: i learnt something new =)
Post back if you don't have it sorted.
EVERYTHING WORKING NICELY.
ONE LAST CONCERN...I HAVE NOT BEEN ABLE TO VERIFY THAT PERSONAL.XLSB IS HIDDEN.
I GUESS MAYBE MY PROBLEM IS IT'S VBA INSTEAD OF LOOKING LIKE A SPEADSHEET?
RE: ''sorry if i am giving you too many links'' ... THE LINKS ARE JUST FINE AND MUCH APPRECIATED.
another problem---
i have another excel macro enabled spreadsheet. when i click on alt-F8, when the macro window
pops up all ''click-on'' buttons are muted. i was expecting otherwise because my understanding is
that the personal.xlsb workbook is always available in all workbooks?
please advise
your queries on Personal.xlsb should be answered here
http://www.rondebruin.nl/win/personal.htm
basically yes personal.xlsb should open every time you open excel
yes its hidden
hmmm muted buttons not sure
have not come across this before
attachments #1 and #2 demonstrate that the macro is accessible for use in the workbook
we have been discussing in this tread.
attachment #3 shows what happens when I try to use the macro in a brand new workbook.
all fields are muted making the macro unusable?
the new workbook is .xlsm and macros are enabled.
please offer thoughts, etc.
that looks like you have no saved the macro into your personal.xlsb file or maybe it has not been created
as the macro code is in the workbook itself
do the section on Ron's website
How do you create the file if it does not exist:
and then see if you can see macro under personal
if you can then you probably did not save last time you closed excel
my perception of this is:
in post #32....
attachment #1 says that personal.xlsb exists.
attachment #2 displays the correct vba code to be in personal.xlsb
so if personal.xlsb is automatically available in all workbooks, why is in not available in the second newly created workbook?
sorry delay...went away for the weekend
Attachment 1 shows personal.xlsb exist but there is no macro there
which is why i eluded to
you have no saved the macro into your personal.xlsb file
attachment #2 actually confirmed the code is not in personal.xlsb
if you have saved into personal.xlsb it should look like this the attachment i added
delay is not a problem.... great help resources must be treated gently and with respect.
no hurry anyhow. I will play around with this within the next few days. busy with something
else at the moment
thanks again
just tried to add to your reputation again but they say I have to spread it around first.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks