Search results for query: *

thanks have answered now....

thanks I was worried as those cells are validated and copying over them ignores the validation rules.... phew!!!! you saved me,,

Can anyone please tell me how to stop people pasting into a protected spreadsheet into the cell that are unlocked?

I have a spreadsheet that is protected. cells (B7:B26) are unlocked for user entry, but i want the cells to retain the format of have boxes around them and being coloured light turquoise even though the user may paste into them. At the moment when i paste into the cell it changes to whatever...

PH, the only thing is that how do i close the application that opens to play it once it has done?

YES this helps!!!!!! Thanks PH

in excel!!!

I have a recorded sound file gtes.wav and when i push pbut1 button i want the recorded sound to play I this possible?

where do i put this code into my application to disable the question of enabling or not?

Hi I want to rid of all the visible commandbars per spreadsheet upon opening then making then same commandbars that were made invisible to be visible again upon exiting. is this possible?

Hi I want to rid of all the visible commandbars per spreadsheet upon opening then making then same commandbars that were made invisible to be visible again upon exiting. is this possible?

Hi I have a protected spreadsheet with user input into cells F5, D8:D27 and L3 at the moment the user inputs into F5 then presses tab which takes him to D8, D9 etc then L3. I would like the user to input into F5 the tab to L3 then D8, D9, etc... Can this be done?

thanks skip will have a go at that now...

thanks for the response skip but what code do i need to do that? I understand a dummy sheet but what code in the open event? sorry to be a pain.

I have an spreadsheet that has macros in it but i don't want people to disallow the macros enabling. Thanks

thanks all...

thanks keith,

I have a cell in Excel that has list values of mmol/L or mg/dl on the drop down, the problem is is that when you chose the drop down it gives you ver small writing, the question is how do i make the text bigger... thanks G.

KLAZ, thanks for your reply, will have a look at this..

Hi Does anyone know to derive the non-centrality parameter in SAS probability functions. Thanks