F Futility Forum Expert Aug 20, 2017 #2 Try mo po ito ts ► You do not have permission to view the full content of this post. Log in or register now. Upvote 0 Downvote
Try mo po ito ts ► You do not have permission to view the full content of this post. Log in or register now.
K Kean_06 Addict Aug 20, 2017 TS TS #5 Futility said: Ano pong version ng excel niyo pong gamit? Click to expand... Excel 2007 po Upvote 0 Downvote
F Futility Forum Expert Aug 20, 2017 #6 2007 rin po sa akin. Gumagana naman po yung method. Tested ko na po yan. Upvote 0 Downvote
F Futility Forum Expert Aug 20, 2017 #8 Ito na lang po, steps na lang: Press Alt + F11. Double click niyo po yung Sheet 1(Sheet1) doon sa kaliwa. I-paste niyo po doon sa lalabas na window yung code. Pagkatapos, press F5. Antayin... Attachments You do not have permission to view the full content of this post. Log in or register now. Upvote 0 Downvote
Ito na lang po, steps na lang: Press Alt + F11. Double click niyo po yung Sheet 1(Sheet1) doon sa kaliwa. I-paste niyo po doon sa lalabas na window yung code. Pagkatapos, press F5. Antayin...
K Kean_06 Addict Aug 20, 2017 TS TS #9 Iba po yung lumalabas pag alt f11 ang pinipindot ko po. Upvote 0 Downvote
F Futility Forum Expert Aug 20, 2017 #10 Kean_06 said: Iba po yung lumalabas pag alt f11 ang pinipindot ko po. Click to expand... Paki-screenshot po nung lumabas. Upvote 0 Downvote
Kean_06 said: Iba po yung lumalabas pag alt f11 ang pinipindot ko po. Click to expand... Paki-screenshot po nung lumabas.
K Kean_06 Addict Aug 20, 2017 TS TS #11 Ganyan po Attachments You do not have permission to view the full content of this post. Log in or register now. Upvote 0 Downvote
F Futility Forum Expert Aug 20, 2017 #12 Yung Alt + F11 po ganito po ang pag-execute. Long press/hold niyo po yung Alt tapos press F11. Hindi po sila magkahiwalay pipindutin. Upvote 0 Downvote
Yung Alt + F11 po ganito po ang pag-execute. Long press/hold niyo po yung Alt tapos press F11. Hindi po sila magkahiwalay pipindutin.
K Kean_06 Addict Aug 20, 2017 TS TS #13 Project is unviewable Attachments You do not have permission to view the full content of this post. Log in or register now. Upvote 0 Downvote
F Futility Forum Expert Aug 20, 2017 #14 Kean_06 said: Project is unviewable Click to expand... Click niyo po yung Share Workbook. Tapos, i-uncheck niyo po yung "Allow changes by more than one user at the same time. This also allows workbook merging." na checkbox. Attachments You do not have permission to view the full content of this post. Log in or register now. Upvote 0 Downvote
Kean_06 said: Project is unviewable Click to expand... Click niyo po yung Share Workbook. Tapos, i-uncheck niyo po yung "Allow changes by more than one user at the same time. This also allows workbook merging." na checkbox.
K Kean_06 Addict Aug 20, 2017 TS TS #15 H Futility said: Click niyo po yung Share Workbook. View attachment 223523 Tapos, i-uncheck niyo po yung "Allow changes by more than one user at the same time. This also allows workbook merging." na checkbox. View attachment 223524 Click to expand... hindi po pwede i uncheck nakalock po Upvote 0 Downvote
H Futility said: Click niyo po yung Share Workbook. View attachment 223523 Tapos, i-uncheck niyo po yung "Allow changes by more than one user at the same time. This also allows workbook merging." na checkbox. View attachment 223524 Click to expand... hindi po pwede i uncheck nakalock po
F Futility Forum Expert Aug 20, 2017 #16 Naka-protect ata yung Workbook mismo. Yung solution po kasi sa worksheet lang e. Hanap lang po ako paraan para ma-unprotect yung workbook. Upvote 0 Downvote
Naka-protect ata yung Workbook mismo. Yung solution po kasi sa worksheet lang e. Hanap lang po ako paraan para ma-unprotect yung workbook.
P painfredz03 Addict Aug 20, 2017 #17 Ito TS subok ko sa ms office 2017. Futility said: Ito na lang po, steps na lang: Press Alt + F11. Double click niyo po yung Sheet 1(Sheet1) doon sa kaliwa. View attachment 223514 I-paste niyo po doon sa lalabas na window yung code. Pagkatapos, press F5. Antayin... Click to expand... Pag di okay sau Right click niyo po iyong sheet then copy to new workbook... Tried and tested ko na ito sa 2007,2013 at 2016 na excel. GL Sana makatulong Upvote 0 Downvote
Ito TS subok ko sa ms office 2017. Futility said: Ito na lang po, steps na lang: Press Alt + F11. Double click niyo po yung Sheet 1(Sheet1) doon sa kaliwa. View attachment 223514 I-paste niyo po doon sa lalabas na window yung code. Pagkatapos, press F5. Antayin... Click to expand... Pag di okay sau Right click niyo po iyong sheet then copy to new workbook... Tried and tested ko na ito sa 2007,2013 at 2016 na excel. GL Sana makatulong
K Kean_06 Addict Aug 20, 2017 TS TS #18 Futility said: Naka-protect ata yung Workbook mismo. Yung solution po kasi sa worksheet lang e. Hanap lang po ako paraan para ma-unprotect yung workbook. Click to expand... Salamat po sa pagtulong boss. Upvote 0 Downvote
Futility said: Naka-protect ata yung Workbook mismo. Yung solution po kasi sa worksheet lang e. Hanap lang po ako paraan para ma-unprotect yung workbook. Click to expand... Salamat po sa pagtulong boss.
K Kean_06 Addict Aug 20, 2017 TS TS #19 painfredz03 said: Ito TS subok ko sa ms office 2017. Pag di okay sau Right click niyo po iyong sheet then copy to new workbook... Tried and tested ko na ito sa 2007,2013 at 2016 na excel. GL Sana makatulong Click to expand... Sinubukan ko na din po yan pero ayaw. Upvote 0 Downvote
painfredz03 said: Ito TS subok ko sa ms office 2017. Pag di okay sau Right click niyo po iyong sheet then copy to new workbook... Tried and tested ko na ito sa 2007,2013 at 2016 na excel. GL Sana makatulong Click to expand... Sinubukan ko na din po yan pero ayaw.